MySQL Forums
Forum List  »  General

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
October 13, 2010 08:34AM
October 13, 2010 12:40PM
October 13, 2010 10:56PM
October 14, 2010 01:07AM
October 14, 2010 08:26AM
October 17, 2010 08:54PM
October 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.