09-08-2008, 10:08 AM
Quote:MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers, gives recommendations which variables you should adjust in order to increase performance. That way, you can tune your my.cnf file to tease out the last bit of performance from your MySQL server and make it work more efficiently...
full article: http://www.howtoforge.com/tuning-mysql-p...mysqltuner
MySQL Tuner: http://rackerhacker.com/mysqltuner/