Re: Maximum number of user conect at time
Posted by:
Rick James
Date: December 18, 2013 01:39PM
SHOW VARIABLES LIKE 'max_connections';
In recent versions, it is defaulted to 151. You can change it via my.cnf (my.ini).
I would venture to say that 80% of installations should be happy with 151; another 10% might need 1000; only a few need more than that.
Generally, if you run out of connections, you should change how the application works rather than increasing max_connections.
Subject
Views
Written By
Posted
1549
December 16, 2013 02:57AM
Re: Maximum number of user conect at time
733
December 18, 2013 01:39PM
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.