too many database connections

Discussion in 'MySQL' started by roimil, Feb 16, 2010.

  1. #1
    i built a site for a client with cms where he can update its content.

    when i showed him the cms and explained him how it is working
    we ran into a problem.

    on my computer i was logged in to the cms,
    and when he tried to connect to the cms with his laptop (with another internet-connection) on the same time, we got a "too many databse connections error"

    of course it was a new site and i guess it was only me and him on it.
    (probably not too many users)

    my face became bright white!

    i want him to have maybe 3 (or more) staff members with access to the cms
    and update their site content.

    what am i doing wrong?
     
    roimil, Feb 16, 2010 IP
  2. duben

    duben Active Member

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    61
    #2
    How many connections you have allowed on your database? Probably you have wrong setup of connection limit, or wrong SQL edition just for development etc. Also you can forgot close connection. Are you using only one open connection during page load, or more? If more, use only one and don't forget to close it.
     
    duben, Feb 17, 2010 IP
  3. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #3
    that's serious.. i think its on your server configuration.. maybe you have a limited access to the database.
     
    bartolay13, Feb 17, 2010 IP
  4. jimmy4feb

    jimmy4feb Peon

    Messages:
    56
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    The number of connections allowed is controlled by the "max_connections" system variable.

    Check its value.

    Thanks,
     
    jimmy4feb, Feb 19, 2010 IP
  5. nvidura

    nvidura Well-Known Member

    Messages:
    1,780
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    150
    #5
    Or if you are pooling connections increase the connection pool size.
     
    nvidura, Mar 16, 2010 IP