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.

too many connections error

Discussion in 'General Discussion' started by bhanuprasad1981, Feb 8, 2010.

  1. bhanuprasad1981

    bhanuprasad1981 Well-Known Member

    Joined:
    Aug 5, 2008
    Messages:
    222
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    one of my client say while tries to make backup of his account , he cant access his site and all visitors are kicked off with message "too many connections" what maybe the issue and solution ?
     
  2. zacharooni

    zacharooni Member

    Joined:
    Feb 11, 2010
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    DataCenter Provider
    Hello,

    It sounds like you have a low max_connections in /etc/my.cnf, try increasing it or getting your host to increase it for you.
     
  3. asiams

    asiams Well-Known Member

    Joined:
    May 28, 2003
    Messages:
    89
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Hokkaido, JAPAN
    optimal connections number for 2GB of memory?

    Hello

    What would be the optimal connection numbers for a server with 2GB of Ram?

    Current setting is 500

    Thanks.
     
  4. jdarow

    jdarow Well-Known Member
    PartnerNOC

    Joined:
    May 30, 2003
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Michigan, US
    cPanel Access Level:
    DataCenter Provider
    That would depend on what each connection is doing... how much server resources each connection is using. Having a low setting will cause errors like you've seen. It's a safeguard. Preventing so many connections that MySQL eats up all your system resources. So, the optimal setting is where MYSQL doesn't kill you server's performance. If it's too low you get errors. If it's too high your server could crash. Unless you're running a very low-end server, 500 connections should be fine. Consider it more as a safeguard than an optimization setting with a perfect value. If your server can handle 500 MySQL connection, 500 is fine.

    Hope that helps.
     
Loading...

Share This Page