Settings optimization

To optimize your settings, we recommend using the following script: https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl

It is important that MySQL has been running for at least 24 hours.

Download and run the script:

wget https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl  --no-check-certificate
chmod +x mysqltuner.pl
./mysqltuner.pl

After the script has been launched, it will display a list of recommended settings. Note that the recommended settings increase RAM and CPU usage of MySQL. It is important to monitor this parameter. Otherwise, the MySQL process will be killed by the OOM killer if there is not enough RAM.