View Full Version : Getting vbulletin Error mysql_connect max_user_connections
kryptonbulbs
05-17-2011, 02:25 AM
"mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User 'XXXXXXXX' has exceeded the 'max_user_connections' resource (current value: 10)"
Getting this error
I have talked with my host about it but they really didnt give me any good answers on it.
Also searched here and google but I havent found much.
Any insite into what exactly this is, problems it may be causing for my users and how to correct it would be appreciated.
Thanks!
Boofo
05-17-2011, 02:43 AM
Who is your hosting company? max_user_connections (current value: 10) is way too low. Even hostgator does better than that.
kryptonbulbs
05-17-2011, 03:25 AM
It is Webair.com
It is a "virtual" plan, I have asked them even before I started the forum if I needed to make upgrades but they didnt say I did.
This error boggles me a little, the forum has had up to 43 users on at once and at that time gave no errors, Is it 10 actions performed within a said time period?
I asked the host if they can increast it or if I need to get a better plan to have it increased. They told me I could upgrade, but it shoudnt be needed. They also did not tell me what it would be increased to with a different plan.
Im going to go open another support ticket with them now.
Thanks for the reply.
In your opinion, what should this be set to, and if you could, please elaborate on it a little bit.
Thanks
Josh
snakes1100
05-17-2011, 04:15 AM
The maximum number of simultaneous connections permitted to any given MySQL user account. A value of 0 (the default) means “no limit.”
Before MySQL 5.0.3, this variable has only a global value that can be set at server startup or runtime. As of MySQL 5.0.3, it also has a read-only session value that indicates the effective simultaneous-connection limit that applies to the account associated with the current session. The session value is initialized as follows:
If the user account has a nonzero MAX_USER_CONNECTIONS resource limit, the session max_user_connections value is set to that limit.
Otherwise, the session max_user_connections value is set to the global value.
To answer your question though, the answer will of course depend on the activity of your users & what they are doing, also what hacks you have installed and what they may be doing as well.
You could try pconnect in your vbulletin config.php, this may allow you to skirt that limit set by them.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.