MySQL Forums :: General :: Question on max_connections


Advanced Search

Question on max_connections
Posted by: abilash vs ()
Date: October 13, 2010 08:34AM

Hi,

Is there a possibility that MySQL server dies totally and stops responding when the connection limit exceeds max_connections without giving any sort of error like "too many connections".

Our production database servers are maintained by a third party and all of sudden one day the servers went down and we have been given an RCA saying many connections were that at a point of time and hence server died down.The DB server has about 16GB RAM and we have set max_connections to a value of 4300.We had set this value very carefully by analysing the max pooling values set in our jboss managed connection poool..Our application logs shows no trace of any error from db end especially "too many connections" .

I am sure MySQL says 'too many connections' when the connections exceed max_connections value and have seen it in past..

It would be helpful if I get some solid inputs on this..

Thanks in advance,
Abilash

Options: ReplyQuote


Subject Written By Posted
Question on max_connections abilash vs 10/13/2010 08:34AM
Re: Question on max_connections William Cross 10/13/2010 11:47AM
Re: Question on max_connections abilash vs 10/13/2010 12:40PM
Re: Question on max_connections Sander de Bruijne 10/13/2010 12:59PM
Re: Question on max_connections Rick James 10/13/2010 10:56PM
Re: Question on max_connections abilash vs 10/14/2010 01:07AM
Re: Question on max_connections Rick James 10/14/2010 08:26AM
Re: Question on max_connections abilash vs 10/17/2010 08:54PM
Re: Question on max_connections Rick James 10/17/2010 10:42PM


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.