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!

MySQL upgraded to 5 and now taking to much CPU

Discussion in 'General Discussion' started by mm1250, Feb 28, 2008.

  1. mm1250

    mm1250 Well-Known Member

    Joined:
    Nov 10, 2006
    Messages:
    108
    Likes Received:
    0
    Trophy Points:
    166
    I had upgraded MySQL to the new version 5 on cPanel but ever since then, mySQL is taking up almost 20-49% CPU according to TOP. It never used to be such a hog like this.

    WHen I go into Show MySQL processes in WHM, there are only like 4-5 different sessions.

    21 eximstats localhost eximstats Sleep 1 NULL
    1465600 leechprotect localhost leechprotect Sleep 7510 NULL
    1497390 cphulkd localhost cphulkd Sleep 15 NULL
    1497457 root localhost NULL Query 0 NULL SHOW PROCESSLIST

    Other than that, I don't know why the darn thing is taking up so much.

    Can someone help?
     
    #1 mm1250, Feb 28, 2008
    Last edited: Feb 28, 2008
  2. mm1250

    mm1250 Well-Known Member

    Joined:
    Nov 10, 2006
    Messages:
    108
    Likes Received:
    0
    Trophy Points:
    166
    anyone please?
     
  3. Tymsah

    Tymsah Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Root Administrator
    i dont know.
    we are using MySQL 4.1.22 version. i have 1.100 Forum on server no problem.

    change /etc/my.cnf settings for performance
     
  4. troxalias

    troxalias Well-Known Member

    Joined:
    Nov 21, 2001
    Messages:
    96
    Likes Received:
    0
    Trophy Points:
    306
    Location:
    Athens - Greece
    1. You could use the utility mytop ( http://jeremy.zawodny.com/mysql/mytop/ ) in order to watch mysql processes in realtime so as to see for some time what's happening on the mysql server.
    2. Tune you /etc/my.cnf file to limit concurrent connection, timeouts, maximum tmp table size, heap sizes etc.
    3. Use a script in order to kill excessive queries and/or number of connections. (i would suggest the one i provide here http://www.cphelp.gr/kb/?View=entry&EntryID=14 :))
     
    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