MySQL Default Connections

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

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).