Register Members List Search Today's Posts Mark Forums Read

Reply
 
Article Options
  #16  
Old 22 Feb 2011, 01:31
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Some webhosts will ban you for this, find a REAL webhost.
__________________
Looking for ImpEx?
Reply With Quote
  #17  
Old 07 Mar 2011, 20:26
thincom2000 thincom2000 is offline
 
Join Date: Jun 2006
Real name: Ted
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.
__________________
- the makers of VaultWiki
Reply With Quote
  #18  
Old 09 Mar 2011, 21:32
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Nope.
__________________
Looking for ImpEx?
Reply With Quote
  #19  
Old 24 May 2011, 11:07
SVTCobraLTD SVTCobraLTD is offline
 
Join Date: Jul 2007
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
Reply With Quote
  #20  
Old 25 May 2011, 02:11
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
SVT, it wont in your case, your mysql server has reached the GLOBAL limit, not your user limit.
__________________
Looking for ImpEx?
Reply With Quote
  #21  
Old 25 May 2011, 02:24
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Originally Posted by Zachery View Post
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?
Reply With Quote
  #22  
Old 25 May 2011, 10:55
SVTCobraLTD SVTCobraLTD is offline
 
Join Date: Jul 2007
Originally Posted by Videx View Post
I'll bite. How can you tell that from what he posted?
I was wondering the same thing.
Reply With Quote
  #23  
Old 26 May 2011, 08:02
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
"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.
__________________
Looking for ImpEx?
Reply With Quote
  #24  
Old 04 Jun 2014, 11:00
yahsuah yahsuah is offline
 
Join Date: Jul 2005
THANK YOU Zachery!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Article Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 01:11.

Layout Options | Width: Wide Color: