MySQL Forums
Forum List  »  General

mysql max_connections
Posted by: Irfan Ali
Date: December 11, 2009 01:26AM

Hello,

our server max_connections limit set to 200. But sometimes it ran out max_connections which gives error "Too many connections". Can someone please let me know after getting this error what happen with incoming connections from application like i am wondering about write queries which come after too many connection either those incoming connections remains in queue which will be executed after finishing earlier connections or upcoming connections get lost ?

One more question what is maximum size limit for buffer_size in MySQL 5.1. Is there any way to increase buffer size from 4GB which is maximum limit till MySQL 4.1.

Thanks,
Irfan

Options: ReplyQuote


Subject
Written By
Posted
mysql max_connections
December 11, 2009 01:26AM
December 12, 2009 03:56PM
December 16, 2009 11:59PM
December 17, 2009 12:39AM
December 20, 2009 11:39PM
December 22, 2009 12:37AM
December 24, 2009 02:01PM
December 25, 2009 12:49AM
December 25, 2009 03:30AM
December 25, 2009 03:49AM
December 25, 2009 11:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.