MySQL CPU load

saggel

• November 22, 2019 16:20

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

  • November 22, 2019 21:56

  try this: watch mysqladmin processlist
  

  0
• 

  saggel

  • November 23, 2019 09:04

  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!

  0
• 

  WebHostPro

  • November 24, 2019 11:21

  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.

  0
• 

  cPanelLauren

  • November 25, 2019 21:10

  I'd suggest checking out the forums thread here: MySQL Governor is an option if you happen to be running CloudLinux

  0

Please sign in to leave a comment.