- Plesk for Linux
Huge value of CPU usage of mysql (more than 100% in peaks).
Multiple "slow queries" to database, according to How to troubleshoot High CPU usage by MySQL? article.
myqsl database server is not tuned/optimized.
Note : Enlarging values may assume server performance. Made sure that you have enough RAM.
Allocate RAM memory for innodb
pool_size and query
for Plesk on RedHat based OS (
for Plesk on Debian-based OS):
my.cnfin text editor.
Set the following values in
innodb_buffer_pool_size = 1024M
query_cache_size = 64M
Save file and restart mysql server:
service mysqld restart
Monitor value of CPU during 3-5 minutes.
If CPU usage is still high enlarge current value of
innodb_buffer_pool_sizeon 1024M and
query_cache_sizeon 64M and repeat steps 3-5.