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