MySQL Forums
Forum List  »  InnoDB

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
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.