More speed in MySQL with Tuning Primer Script

This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..." then attempts to produce sane recommendations for tuning server variables. It is compatible with all versions of MySQL 3.23 - 5.1.

• tuning-primer.sh

All downloads

Currently the script handles recommendations for the following: Slow Query Log Max Connections Worker Threads Memory Usage Key Buffer Query Cache Sort Buffer Joins Temp Tables Table (Open & Definition) Cache Table Scans (read_buffer) Table Locking Innodb Status via MySQL Tuning Primer Script.