MySQL Forums
Forum List  »  MySQL Administrator

query on max_connections
Posted by: abilash vs
Date: October 13, 2010 08:36AM

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
query on max_connections
October 13, 2010 08:36AM


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.