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