Slow mysql process

Buzz50

• February 19, 2017 11:24

Can you please let me know if this is a problem? 150.05% CPU /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mail.example.com.err --open-files-limit=10000 --pid-file=/var/lib/mysql/mail.example.com.pid I've attached an image from WHM

• 

  Jcats

  • February 19, 2017 21:15

  MySQL can definitely consume a fair amount of CPU, as long as its not persistent and not using more CPU that other services need. You can't do too much troubleshooting if you are just looking in WHM, you have to get into SSH and monitor the usage using the command
  # top
  If you notice it using a fair amount of CPU then you can run the command:
  # mysqladmin proc
  You can spam it a few times, each time it will list all queries running. You want to check and see if maybe one user keeps popping up very frequently and/or if there is a query(s) that are running for a long time. You can check the 'Time' column, but if the query is in the Sleep state with a high Time, then you can ignore it.

  0
• 

  cPanelMichael

  • February 20, 2017 18:06

  Hello, The information in the previous post should help. Let us know if you have any additional questions. Thank you.

  0

Please sign in to leave a comment.