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 overload making apache fail problem.. help..

Discussion in 'EasyApache' started by ramystyle, May 11, 2004.

  1. ramystyle

    ramystyle Well-Known Member

    Joined:
    Feb 9, 2004
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Montreal
    Hi,

    3 days ago, we received an e-mail from our server with the following subject:
    Subject: [maxclientscheck] has exceeded the MaxClients limit
    Apache has reached the MaxClients
    limit. cPanel has increased the MaxClients limit to 190 (10 higher).

    You may wish to suspend the user with the largest access log as they
    are generally the person using up all of the avalible connections. However, your should
    have your system admin verify this first.

    Top 3 Largest access logs
    ====================================
    160428 /usr/local/apache/domlogs/nordicpiratforum.com
    124472 /usr/local/apache/domlogs/satsiden.com
    124140 /usr/local/apache/domlogs/ffinvincible.nl


    I have raised the MaxClients limit to 250 since we have 1Gigs of Rams on a P4 2.4... So I assumed that our machine can handle it.

    Since then, Apache restarts "automagicly" every 2-3 hours.. I checked what are the top processe running and I get:
    /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/br-bb25cl.privatedns.com.pid --skip-locking
    which uses 99.9% of cpu

    Is it because my clients are having too many connections to MYSQL? If so, what should I do ?

    Thanks

    Ramy
     
  2. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lewisville, Tx
Loading...

Share This Page