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:
mysqltuner
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:
wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl
Make it executable:
chmod +x mysqltuner.pl
And run:
./mysqltuner.pl
The result can also be written to a file:
./mysqltuner.pl > ixnfo.com.txt
See also my article:
Change max_connections in MySQL