Operating System & Version
CloudLinux 7
cPanel & WHM Version
90

DennisMidjord

Well-Known Member
Sep 27, 2016
254
33
28
Denmark
cPanel Access Level
Root Administrator
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

Well-Known Member
Jun 9, 2020
272
55
28
EU
cPanel Access Level
Root Administrator
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

Technical Support Community Manager
Staff member
Nov 14, 2017
13,304
1,247
313
Houston