too much mysql connections

Discussion in 'Site & Server Administration' started by joujoba, Jan 9, 2011.

0
  1. #1
    hello

    i have gotten the error too much mysql connections, i have increased it to 1024 connection, after a few weeks it returned.
    whats the maximum number of connection can i set it too?
    whats recommended?
    thank u
     
    joujoba, Jan 9, 2011 IP
  2. atxsurf

    atxsurf Peon

    Messages:
    2,394
    Likes Received:
    21
    Best Answers:
    1
    Trophy Points:
    0
    #2
    I suppose the might be some limit, but in reality you would max out the CPU first before reaching that limit
    why not to check why you have 1024 connections - do you have 1024 visitors simultaneously or you may have some scripts hanging?
     
    atxsurf, Jan 10, 2011 IP
  3. joujoba

    joujoba Peon

    Messages:
    100
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    no, on database backup i reach that limit while also visitors are visiting
     
    joujoba, Jan 10, 2011 IP
  4. Vadym Kurylovych

    Vadym Kurylovych Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    you using myisam for table storage? if yes I have a bad news for you :)
    1024 is tooooooo much anyway
    normally not more 100
    myisam lock all table while update/insert or run select with join
    take a look on php/apache settings like timeouts
     
    Vadym Kurylovych, Jan 11, 2011 IP
  5. joujoba

    joujoba Peon

    Messages:
    100
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    using mysql
     
    joujoba, Jan 11, 2011 IP
  6. rllunzmann

    rllunzmann Active Member

    Messages:
    1,796
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    80
    #6
    How many websites are hosted on your server that is having this particular issue?
     
    rllunzmann, Jan 11, 2011 IP
  7. joujoba

    joujoba Peon

    Messages:
    100
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    2 on that server 1 running IPB with high traffic
     
    joujoba, Jan 12, 2011 IP