Portal Home > Knowledgebase > Security & Optimization > How to Optimize MySQL with MySQLTuner

How to Optimize MySQL with MySQLTuner

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


1. Download MySQLTuner:

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

# chmod 755 mysqltuner.pl

2. Run MySQLTuner:

# ./mysqltuner.pl

Configuration can be set in the /etc/my.cnf file.

Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read