MySQL Problem: "Too many connections"

Discussion in 'MySQL' started by xpgo, Feb 11, 2008.

  1. #1
    Hello,

    I'm running a vbulletin forum.
    Last month i purchased a dedicated server, only to run my vb forum.
    But, for two times in one week, the server have not been able to get stable all the time. This is causing a downtime on every weekend....

    I think the cause could be the resources used by MySQL.
    I'm getting on the logs this error:


    any hint to prevent this happening?
    Thank you
     
    xpgo, Feb 11, 2008 IP
  2. SoKickIt

    SoKickIt Active Member

    Messages:
    305
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    70
    #2
    Edit the "my.cnf" file (/etc/my.cnf) and set a larger value for the "max_connections" variable. It's probably set to 100, try 200. If that doesn't help, you should try other options.

    Remember to restart MySQL after making those changes.
     
    SoKickIt, Feb 11, 2008 IP