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.

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:
    59
    Likes Received:
    0
    Trophy Points:
    6
    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:
    59
    Likes Received:
    0
    Trophy Points:
    6
    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:
    447
    Likes Received:
    4
    Trophy Points:
    18
    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.

     
    #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:
    16
    Location:
    Nasik (Maharashtra), India
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page