MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.

*WARNING*It is extremely important for you to fully understand each change you make to a MySQL database server. If you don't understand portions of the script's output, or if you don't understand the recommendations, you should consult a knowledgeable DBA or even a system administrator that you trust. Always test your changes on staging environments, and always keep in mind that improvements in one area can negatively affect MySQL in other areas.

Running MySQLTuner:
Download MySQLTuner using the following command

# wget http://mysqltuner.com/mysqltuner.pl

To run the script, simply make it executable and run it:

# chmod +x mysqltuner.pl# ./mysqltuner.pl

Enter your administrative username and password
Output you can see as follows