MySQL CPU load

[saggel]

The MySQL use on my dedicated server has a load of 150-200% (which at times reaches 250-300%) and points at

/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!

 

[quietFinn]

try this:

watch mysqladmin processlist

 

[saggel]

try this:

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!

 

[WebHostPro]

Yeah there isn't a strong MySQL regulator, optimizer, or throttle for cPanel yet. I have tried a couple and none were reliable.

Your best bet is to restart mysql and maybe restart the server to see if that helps.

 

[cPanelLauren]

I'd suggest checking out the forums thread here: Tutorial - Troubleshooting high server loads on Linux servers

MySQL Governor is an option if you happen to be running CloudLinux