MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

wget http://mysqltuner.pl/ -O mysqltuner.pl
perl mysqltuner.pl

Script read-only : il ne fera que vous donnez des conseils pour l'optimisation, il ne touche à rien.