High MySQL CPU usage

[DennisMidjord]

Ever since we started using cPanel, MySQL has been one of the processes that is most resource hungry.
MySQL os always using at least 100% CPU, and most of the time more than that (between 100-250%). Executing `mysqladmin pr` shows close to 0 processes (primarily Daemon and Sleep commands.

I've been taking a look at mysqltuner multiple times, but CPU usage isn't impacted by any of the changes I do.

Can someone point us in the right direction?

 

[andrew.n]

Have a look at MySQL process list in WHM..that might be useful to pinpoint the query causing it. I would also have a look at the log files in /var/lib/mysql/hostname.err to see if any of the tables are crashed or needs repair.

 

[cPanelLauren]

You might also want to enable the slow log which can be helpful in identifying MySQL queries that may be causing a lockup MySQL :: MySQL 5.7 Reference Manual :: 5.4.5 The Slow Query Log