saggel

Registered
Nov 22, 2019
2
0
1
Netherlands
cPanel Access Level
Root Administrator
The MySQL use on my dedicated server has a load of 150-200% (which at times reaches 250-300%) and points at

Code:
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --open-files-limit=12000 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
could you help me find where the problem is?

Thank you in advance!
 

saggel

Registered
Nov 22, 2019
2
0
1
Netherlands
cPanel Access Level
Root Administrator
try this:
Code:
watch mysqladmin processlist
Thank you for your response!

I've also been following this from:

Home »SQL Services »Show MySQL Processes

I don't see anything problematic there to report!

That's why I don't understand why I get this load!

If that helps, I do sometimes see a few "sleep" processes but they don't last long!

The main queries appearing there are from a Wordpress site but they process fast!

Do you need me to post some examples or is there something else I could do?

Thanks again and I really appreciate your help!
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,297
1,251
313
Houston