The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Slow mysql process

Discussion in 'Database Discussions' started by Buzz50, Feb 19, 2017.

  1. Buzz50

    Buzz50 Member

    Joined:
    Apr 23, 2012
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    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
     

    Attached Files:

    #1 Buzz50, Feb 19, 2017
    Last edited by a moderator: Feb 19, 2017
  2. Jcats

    Jcats Well-Known Member

    Joined:
    May 25, 2011
    Messages:
    588
    Likes Received:
    88
    Trophy Points:
    153
    Location:
    New Jersey
    cPanel Access Level:
    DataCenter Provider
    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

    Code:
    # top
    If you notice it using a fair amount of CPU then you can run the command:

    Code:
    # 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.
     
    cPanelMichael likes this.
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,285
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thank you.
     
Loading...

Share This Page