MySQL Forums
Forum List  »  Newbie

SQLSTATE[08004] [1040] Too many connections
Posted by: Mark Hunkler
Date: August 31, 2011 03:11PM

I keep getting this error on my site and I do not know how to diagnose the problem. The only thing I can do is reset my server and then its ok.

From what i have read searching Google for this problem, you can try changing max connections in my.cnf I went into that file and there was nothing in there about max connections so i added the code I saw and set the connections high. I must not have had the code right though bc it didn't work at all until i removed the code and rebooted again.
What is the correct coding I should try to see if this fixes the problem?

However, our dedicated server does not get that much traffic, maybe 500 a day on a total of 7 sites, so I don't think there is really that many connections simultaneously. From something else I read, I think its more of a problem with connections being left open and then eventually there is "Too Many Connections". However I have no idea how to check this out and see...

I just want to add that we never had this problem until recently, and the only thing that has changed recently was adding a new site that only gets like 5 hits a day so far, and I really don't think it has anything to do with that site but it was the last change and this problem started maybe a week or two later.

I'm running MySQL 5.1.52... I'm wondering if I should upgrade and maybe all my problems will be solved magically lol? But being a newbie, I don't want to mess with anything i don't have to... I read any server software downloaded in a RPM package should be upgraded in a package too?? Like I should upgrade PHP and apache and everything too... I'm in over my head here. lol

Thanks for any advice you guys may have for me.

Options: ReplyQuote

Written By
SQLSTATE[08004] [1040] Too many connections
August 31, 2011 03:11PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.