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):

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.