is a perl script for mysql optimization.
To get uset it:
wget http://mysqltuner.com/mysqltuner.pl
chmod +x mysqltuner.pl
./mysqltuner.pl
I acheived amazing performance boost (server load dropped form 10 to 1) following the suggestions of this script, i.e.:
General recommendations:
Add skip-innodb to MySQL configuration to disable InnoDB
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_size (> 64M)
table_cache (> 64)
Thanks mediakey.dk for introducing this amazing script.
No comments:
Post a Comment