Installing and using mysqltuner.pl

MySQLTuner – This is a Perl script that will give recommendations for improving the performance and stability of the MySQL server.
GitHub Page – https://github.com/major/MySQLTuner-perl

MySQLTuner in Ubuntu can be installed with the command:

sudo apt-get install mysqltuner

In CentOS as follows:

yum install mysqltuner

MySQLTuner is started with the command:

mysqltuner

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

You can also download the script file itself:

wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl

Make it executable:

chmod +x mysqltuner.pl

And run:

./mysqltuner.pl

See also my article:
Change max_connections in MySQL

Подписаться на IT Blog (RU) по Email
Subscribe to IT Blog (EN) by Email

Did my article help you? How about buying me a cup of coffee as an encouragement? Buy me a coffe.

Leave a Reply