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.

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:
    16
    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:
    16
    anyone please?
     
  3. Tymsah

    Tymsah Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    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:
    6
    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 :))
     
Loading...

Share This Page