Re: Question on max_connections
Posted by:
Rick James
Date: October 13, 2010 10:56PM
MySQL does not die when max_connections is hit. It may appear to be dead, in that it is refusing to accept new connections, and the existing connections may be taking "forever".
"+1": If no one is connected with SUPER privilege (which is GRANTed to 'root' by default, and to anyone with "GRANT ALL ON *.*"), then there is one 'extra' connection. This extra is so you can connect as root and see what is going on (SHOW PROCESSLIST) and kill runaway processes (KILL).
In order to allow that privilege, do not have normal usage connecting as root, or otherwise granted SUPER.
Subject
Written By
Posted
Re: Question on max_connections
October 13, 2010 10:56PM
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.