Installing and using

MySQLTuner – This is a Perl script that will give recommendations for improving the performance and stability of the MySQL server.

MySQLTuner in Ubuntu can be installed with the command:

sudo apt install mysqltuner

In CentOS as follows:

sudo yum install mysqltuner

MySQLTuner is started with the command:


If necessary, MySQLTuner will request a login and password to connect.

Instead of installing on the system, you can also download the script file itself:


Make it executable:

chmod +x

And run:


The result can also be written to a file:

./ >

See also my article:
Change max_connections in MySQL

Leave a comment

Leave a Reply