max_user_connections errors :: Prevention Tips

[Ober]

This problem has arrived on my forum in the last week. Members are inconveinanced and have started a complaints thread. I need to get this fixed but its over my head. Is there anywhere I can hire a reputable person to fix this error for me?

Ober

[snakeair]

I have contacted HG support 3 times in 2 days about my "mysql too many connections" error message i get sometimes on my wordpress blog that past 48 hours and they came up with no solution. They said if you can replicate it, so we can take a look. How the heck am i supposed to do that when i don't know how it happened in the first place. I have removed 4 plugins already and been using cloudflare and w3 total cache for many months with no problem. No HG support tech can find out what is the exact reason my issue keeps coming. I'm a long time customer who is already asking for suggestions on a new webhost at the forum i moderate at.

The plugins i removed help protect my blog from spammers and i can't remove more till i know the cause of my too many connections message and how can i fix it? This is killing my traffic this weekend and the support tech's can't seem to investigate more.

[quietFinn]

Originally Posted by snakeair

I have contacted HG support 3 times in 2 days about my "mysql too many connections" error message i get sometimes on my wordpress blog that past 48 hours and they came up with no solution.
...

This is not the same thing as "max_user_connections" error, but it's the server hitting the "max_connections" limit:

C.5.2.7. Too many connections

If you get a Too many connections error when you try to connect to the mysqld server, this means that all available connections are in use by other clients.

The number of connections permitted is controlled by the max_connections system variable. Beginning with MySQL 5.1.15, its default value is 151 to improve performance when MySQL is used with the Apache Web server. (Previously, the default was 100.) If you need to support more connections, you should set a larger value for this variable.

http://dev.mysql.com/doc/refman/5.1/...nnections.html

[snakeair]

I know this question should go somewhere else but in cpanel, i clicked on my mysql username that i created many moons ago and there was about 3 box's not checked. I just checked them all. I dunno if this will make a difference or not.

Just tossing this out there. Thanks for the link.

[bigc1487]

I had this same problem for 5 days in a row about a week ago so i routed all of my traffic to a static page (no database requests) using htaccess. I was still having problems. I couldnt even get into phpmyadmin because of too many connections and was getting an empty phpmyadmin error. I talked to a tech over chat support who said it was probably because of another user on the same server as i was, and there was nothing i could do about it. He said that the other person was using up to the max and since i was on the same server i was getting the same maxed out results. He said that if that was not the problem then it could be from another server error that the admins were working on. I am on gator882, not sure if anyone else on that server has had same problems or not. The tech agreed with me and said the servers were probably overloaded and that the only real solution would be to go to a VPS or dedicated.

[Thesyndicate]

Please suggest what to do with Vbulletin? What robot or other things should i use to prevent Hostgator shutting down my website all the time.