Results 1 to 1 of 1

Thread: MySQL - High Load

  1. #1
    Member
    Join Date
    Feb 2004
    Posts
    26

    Question MySQL - High Load

    Hello,

    Recently my MySQL server has been having rather high loads. It has been pushing the server's load to an average of 4.9 - 5.5 over an extended period of time (5+ hours).

    In order to try and lower the load, I dropped in the my-huge.cnf configuration file, versus the standard my.cnf file (cp'ed and renamed my-huge to my.cnf, backed up my.cnf). After restarting the service, everything seemed fine but once again the load is back up. I have a few large databases around 90-140Mb which is one of the reasons why I moved to the my-huge.cnf.

    The server's specs are Dual 2.8Ghz Xeon HT, with 2Gb of RAM (2Gb swap). The interesting part is that when I run 'top' to check usage I see mysqld as the top process user yet it is only showing as using 0.9% CPU and 18% RAM. I have gone through and checked other processes and they seem fine (low usage). Just in case I ran a rootkit check on the box, and it turned up nothing.

    I am running the latest stable build of WHM/cPanel WHM 9.9.9 cPanel 9.9.9-S15, on Red Hat Linux Enterprise 3.0.

    Help, and ideas would be appreciated.
    -- Thanks

    Added:

    When running 'ps -A':

    18874 pts/3 00:00:00 mysqld_safe
    18900 pts/3 00:00:00 mysqld
    18901 pts/3 00:00:00 mysqld
    18902 pts/3 00:00:00 mysqld
    18903 pts/3 00:00:00 mysqld
    18904 pts/3 00:00:00 mysqld
    18905 pts/3 00:00:00 mysqld
    18906 pts/3 00:00:00 mysqld
    18907 pts/3 00:00:00 mysqld
    18908 pts/3 00:00:00 mysqld
    18909 pts/3 00:00:00 mysqld
    18910 pts/3 00:00:00 mysqld
    18911 pts/3 00:00:00 mysqld

    Quite a lot of mysqld processes appear, even after stoping/starting the service, at least 10 myqld processes return to the process tree.
    Last edited by Jasio; 01-01-2005 at 09:02 PM.
    .:: Fat Caliber Hosting - www.fatcaliber.com - Limitless Possibilities ::.

Similar Threads

  1. High load (mysql)
    By iulian_2007 in forum Optimization
    Replies: 11
    Last Post: 05-23-2011, 05:36 AM
  2. high mysql load
    By itajooba in forum Optimization
    Replies: 4
    Last Post: 09-24-2010, 11:44 PM
  3. High Load Mysql
    By techteen in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 11-09-2007, 07:59 AM
  4. MYSQL High Load Question
    By fulleffect in forum cPanel & WHM Discussions
    Replies: 3
    Last Post: 05-19-2007, 07:23 PM
  5. high load: mysql
    By Secret Agent in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 01-15-2006, 06:44 PM