High MySQL CPU usage

DennisMidjord

• September 04, 2020 05:09

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

  • September 04, 2020 13:22

  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.

  0
• 

  cPanelLauren

  • September 04, 2020 22:22

  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

  0

Please sign in to leave a comment.