If you haven’t checked out my automated mysqltuner.pl script, head on over to mysqltuner.com and give it a try. The script is written in Perl, and it’s an automated way to optimize your MySQL variables for the best performance. It’s like being able to ask a DBA to fix your variables, except the script is free, it doesn’t require coffee to function (only Perl), and it gives immediate results.

Changes for tonight:

• Fixed some of the logic for key buffer calculations
• Added a warning if MySQL hasn’t been running very long
• Additional detailed explanations
• Checks for max_seeks_for_key variable