Plesk: Increase MySQL database performance
To increase the performance of the database in Plesk, there is a relatively simple way by setting up another cache, so to speak. All we need is enough available memory. In many cases, this should already result in slow database queries finally running faster.
To make the change the corresponding configuration file must be opened and adjusted, this is possible with vi or nano:
vi /etc/mysql/my.cnf
Then the following values must be added or adjusted under [mysqld]:
innodb_buffer_pool_size=1024M
query_cache_size=64M
After that, the database server must be restarted:
systemctl restart mysqld
If this also does not lead to any improvement, all existing databases can be additionally optimized, this is possible with the following command:
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqlcheck -uadmin --optimize --all-databases
If the database server has been running for a few days, direct recommendations can also be retrieved using a tool. For this we install
apt-get install mysqltuner
the MySQL Tuner tool and then run it:
mysqltuner