Using up too many mysql connections. - Help!

Discussion in 'Site & Server Administration' started by kemus, Aug 31, 2007.

0
  1. #1
    Hi,

    One of my sites is currently getting a good chunk of traffic daily. It is mysql-database driven, and the databases have been optimized as much as possible.

    Still, it is using more than the 25 concurrent 'server process' limit at hostgator and they want me to pay $175/month for a dedicated server to remove that limit.

    I am wondering if any reliable, well-known host offers a plan with more than 25 concurrent server processes on a plan that is NOT a dedicated server.
     
    kemus, Aug 31, 2007 IP
  2. cyanide

    cyanide Peon

    Messages:
    483
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #2
    What kind of site is it and what's your budget?
     
    cyanide, Aug 31, 2007 IP
  3. InFloW

    InFloW Peon

    Messages:
    1,488
    Likes Received:
    39
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Make sure you're not using mysql_pconnect (persistent connections). This can clog up connections.
     
    InFloW, Sep 1, 2007 IP
  4. arcade32

    arcade32 Peon

    Messages:
    659
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #4
    i had this problem too with a shared host try a vps i e never had one so not sure what you could do with it but i had to move to a dedicated server to get rid of the problem

    its about the only thing you can do
     
    arcade32, Sep 1, 2007 IP