[Zachery]

Some webhosts will ban you for this, find a REAL webhost.

[thincom2000]

Is there any other benefit from spreading the connections over multiple accounts (slight performance gain, maybe)? I just moved to a dedicated server, and am wondering if I even need this any more.

[Zachery]

Nope.

[SVTCobraLTD]

I am going to try this, hopefully it eliminates my errors:

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home/xxxxxxx/forums/includes/class_core.php on line 311

[Zachery]

SVT, it wont in your case, your mysql server has reached the GLOBAL limit, not your user limit.

[Videx]

Originally Posted by Zachery

SVT, it wont in your case, your mysql server has reached the GLOBAL limit, not your user limit.

I'll bite. How can you tell that from what he posted?

[SVTCobraLTD]

Originally Posted by Videx

I'll bite. How can you tell that from what he posted?

I was wondering the same thing.

[Zachery]

"Too many connections" is not the same as "User x already has more than 'max_user_connections' active connections"

to many connections, indicates that the mysql server itself has 0 available slots for mysql connections. Where max_user_connections indicates that a specific mysql user has reached the maxed limit.

To many connections is a semi-hard limit defined in the my.ini/my.cnf file
max_user_connections can be imposed at several areas, one of which is my.cnf/my.ini, but additionaly in the mysql user table specificly.

It is funny, sometimes i see single site servers setup with a max_connection limit of 100, so mysql allocates enough resources to have 100 connections. But they limit their one and only mysql user to something like 30 connections. If you only want mysql to handle 30 connections, only give it 30.

Now I am ranting

Though, 9 years working with vB, and 7 of those in support, has tought me many things.

[yahsuah]

THANK YOU Zachery!