MySQLTuner : Suggestions for optimizing your MySQL installation

MySQLTuner is a script that will assess MySQL performance and recommend steps to maximize performance. To install and run MySQLTuner, log in to your VPS as the root user and follow these steps (for CentOS):

Download MySQLTuner:

make it executable

Run MySQLTuner:

 

This is the result I got from a recently created vps I have running with a wordpress blog with very few visitors.

Look at the results, rows starting with [!!] are issues that you need to look into. At the end, after the checks are done, recommendations for your installations are given. Many of the recommendations are easy to follow and if there is a recommendation to change a variable, it is most likely done in the /etc/my.cnf file.

 

If you are uncertain about any results you get, feel free to post your questions below in the comments.

2 comments for “MySQLTuner : Suggestions for optimizing your MySQL installation

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.