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:
If necessary, MySQLTuner will request a login and password to connect.
You can also download the script file itself:
Make it executable:
chmod +x mysqltuner.pl
See also my article:
Change max_connections in MySQL