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 annoyance = server load issues!

Discussion in 'General Discussion' started by robbie_troster, Aug 11, 2009.

  1. robbie_troster

    robbie_troster Well-Known Member

    Joined:
    Mar 26, 2009
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    This is really starting to bug me...

    This process keeps running and it really is hurting the server in CPU... when it runs it makes the server load jump up to about 11.5

    /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/node2.infusiondns.com.pid --skip-external-locking

    Why is it doing it?
     
  2. 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
    run this command for a while to know which database has the highest activity.

    watch 'mysqladmin processlist'
     
  3. thewebhosting

    thewebhosting Well-Known Member

    Joined:
    May 9, 2008
    Messages:
    1,201
    Likes Received:
    1
    Trophy Points:
    38
    Check in WHM -> MySQL Process List. It will show you database and userwise process list of MySQL.
     
  4. jacks

    jacks Active Member

    Joined:
    Nov 15, 2004
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    was is mysql or something else?
     
  5. robbie_troster

    robbie_troster Well-Known Member

    Joined:
    Mar 26, 2009
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    Nothing out of the ordinary in the process list. Strange though...

    I'll have to look further... I do have some Auto DJ servers set up.. But that is on an Xeon Dual Quad Core 2.83GHz... shouldn't spike the server at all.
     
  6. sibu

    sibu Member

    Joined:
    Jul 14, 2006
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    Is your mysql issue is resolved. Please make sure that the load is happening because of the mysql.

    If the load issue still persists please execute the following commands on the server shell and check which process is taking the load

    ps -eo pcpu,pid,user,args | sort -r -k1 | more


    Thanks
    Sibu Skariah :)
    LinuxHelps.com
     
  7. Fernis

    Fernis Well-Known Member

    Joined:
    Oct 28, 2006
    Messages:
    192
    Likes Received:
    1
    Trophy Points:
    18
    I am having the same issue and can't figure out why this is happening. I do see one account that has an active vbulletin message board, but wouldn't think it would cause a constant cpu load of 80% by mysql.
     
  8. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    Depending on how many simultaneous users you get as traffic on the vbulletin site, that very much can cause high loads especially even more so if your MySQL server isn't configured, indexed, or optimized properly or if you have limited resources on the server to be able to handle higher traffic from a single point, memory, network card, CPU, etc

    Going beyond the above, the number of accounts you have on the server outside the account with the vBulletin site also play a large factor as well. Then again, it is entirely possible you have some other additional issue or other factor going on with your server that may play into the end result on total load levels.

    I would have to evaluate your server to be able to tell you more precisely what is going on but that should give you a general idea as to the directions in which to focus. I would also update your "my.cnf" to setup logging of slow queries which will help clue you in on unoptimized or more heavily loaded databases.
     
    #8 Spiral, Sep 26, 2009
    Last edited: Sep 26, 2009
  9. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,482
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    An out of date addon of some sort or busy chat / shoutbox script possibly?
     
  10. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    I am sure everyone already knows this but if the "eximstats" tables haven't been cleared in a while, they can sometimes grow too large and overload the MySQL server. Just a side FYI.
     
Loading...

Share This Page