mySQL Too Many Connections Open error
Hi All...my website is 95% PHP driven with a mySQL connection at the top of every page. The site has been operational since earlier this year with no issues. Lately, though, my site has been erroring with a "Too many coonections open" error. This is not only happening when launching my site, but also attempting to log into my VDECK/mySQL account with iPower.com.
The first time I saw this error was last Wednesday at 2:PM Central time when I tried to test some new code. FYI: I currently do not average a lot of hits, less so at 2:PM in the afternoon on a Wednesday! I refreshed around 5-7 times and my site finally launched. I then logged into vdeck to update a table and the error occurred again.
I then tried to talk to iPower and hung up after a 45 minute wait time.
I periodically checked the site since and experienced the error again last night. This time, I got on the horn with iPower with a desire to hold indefinitely. NOT to my surprise, tbe level-1 could not duplicate it. He later instructed me (with the "help" of a level-2 or level-3) to "clear my browser cache" and re-try. Hmm...
This morning, I received an email from a visitor showing me the same sql error she received over night. She indicated she was finally able to enter my site but only after refreshing a few times. I then contacted iPower and managed to speak to a somewhat intelligent level-1. After some convincing, he took my vdeck id and pw, signed in, then immediately received the mySQL error while attempting to log in.
After further hold time, he reminded me his company was upgrading all acounts to the new VDECK system and servers. He prioritized my site's upgrade (to new VDECK version) to immediate status. But, he told me this is a common issue as a result of not properly releasing the DB.
I need some help here...I don't believe it's due to my site because:
1) Every page of mine has a release statement prior to the </html> statement
2) It's been operational for almost a year with no issues
3) My highest visit rate, early November, produced my highest sales
4) Error occured trying to login to VDECK/mySQL (not just visiting my site).
Please comfort me and assure me that "I see stupid people" out there (borrowed from "I see dead people")...
Thanks everyone!
|