Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

SQL doing Too Much Process & taking too much Resources

Discussion in 'Workarounds and Optimization' started by rohit09, Sep 4, 2011.

  1. rohit09

    rohit09 Well-Known Member

    Joined:
    Dec 10, 2010
    Messages:
    60
    Likes Received:
    0
    Trophy Points:
    56
    My VPS keep overload due to a SQL process. Process: 235

    The process is:

    Code:
    /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server145.mydomain.com.err --pid-file=/var/lib/mysql/server145.mydomain.com.pid
    

    It takes up pretty much 90-95% of the cpu and memory at times if I do not kill the process. But even after I kill the process it comes back and immediately hogs up cpu load again causing it to go into loads of 27.00 or higher ( I have 4cpus ).

    Any solution?

    Thanks
     
  2. rohit09

    rohit09 Well-Known Member

    Joined:
    Dec 10, 2010
    Messages:
    60
    Likes Received:
    0
    Trophy Points:
    56
    When I'm trying to restart the SQL

    What should I do? :(
     
    #2 rohit09, Sep 4, 2011
    Last edited: Sep 4, 2011
  3. JawadArshad

    JawadArshad Well-Known Member
    PartnerNOC

    Joined:
    Apr 8, 2008
    Messages:
    458
    Likes Received:
    6
    Trophy Points:
    68
    Location:
    PK
    cPanel Access Level:
    DataCenter Provider
    Try and restart MySQL a couple of times including other services that are apparently consuming high resources under "WHM > Process Manager". If the service doesn't respond in a reasonable amount of time, cPanel may report it as a failed restart.
    Check "Show MySQL Processes" in WHM to find out which MySQL queries are running at the time of high load and then you can start optimizing your queries.

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 JawadArshad, Sep 4, 2011
    Last edited: Sep 4, 2011
  4. milind

    milind Well-Known Member

    Joined:
    Jan 15, 2006
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Nasik (Maharashtra), India
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice