Submitted by brucelet on Mon, 05/10/2010 - 09:16
What are the default number of connections for MySQL? We are having an issue with some of our PHP/MySQL apps getting unavailable errors and have to restart MySQL to resolve it.
Thanks.
Status:
Active
Comments
Submitted by andreychek on Mon, 05/10/2010 - 09:21 Comment #1
Howdy -- the exact connection limit depends on the particular MySQL version you're using, but it's likely either 100 or 150.
You can read about the connection limits here:
http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html
Depending on the nature of the problem you're seeing, you may want to explore increasing the connection limit, and possibly increasing the open files limit for the MySQL user (the latter can be changed in /etc/security/limits.conf).