MySQL Forums :: General :: mysql max_connections


Advanced Search

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 Irfan Ali 12/11/2009 01:26AM
Re: mysql max_connections Rick James 12/12/2009 03:56PM
Re: mysql max_connections Irfan Ali 12/16/2009 11:59PM
Re: mysql max_connections Rick James 12/17/2009 12:39AM
Re: mysql max_connections Irfan Ali 12/20/2009 11:39PM
Re: mysql max_connections Rick James 12/22/2009 12:37AM
Re: mysql max_connections Irfan Ali 12/24/2009 02:01PM
Re: mysql max_connections Rick James 12/25/2009 12:49AM
Re: mysql max_connections Irfan Ali 12/25/2009 03:30AM
Re: mysql max_connections Irfan Ali 12/25/2009 03:49AM
Re: mysql max_connections Rick James 12/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.