Set the maximum allowed number of connections in MySQL

Set the maximum allowed number of connections in MySQL

Answer:

MySQL has a setting which prevent the database from overloaded due to too many concurrent connections. This value should depends on the processing power of your database server, e.g. CPU, memory, disks I/O.

To change the value, edit the MySQL configurations, e.g. /etc/my.cnf

..
max_connections=100
..

So if a client connecting to the database exceeded this value, they will be blocked.

Don't forget to restart MySQL to take effect.

# /sbin/service mysqld restart

Related posts:

1. Block a client from connecting to MySQL if too many errors
2. Change the maximum allowed binary log file size in MySQL
3. Disable MySQL server from listening for TCP/IP connections
4. Enable external locking in MySQL
5. Enable MySQL binary log (bin log)