How to Increase the Maximum MySQL Connections Beyond the Default Limit?

Increasing MySQL Connections Beyond the Default Limit

In MySQL, each socket connection allows a certain number of concurrent connections, typically set to a default of 100. If you encounter situations where this limit proves insufficient, you can adjust it to accommodate your requirements. Here's how to do it:

Dynamic Adjustment (Without MySQL Restart)

To temporarily increase the maximum connections without restarting MySQL, execute the following query:

mysql> SET GLOBAL max_connections = 150;

Note that this change will only be effective until MySQL is restarted.

Permanent Configuration

For a permanent change, edit your MySQL configuration file (my.cnf) and add the following line:

max_connections = 150

Save the file and restart MySQL to apply the changes.

The above is the detailed content of How to Increase the Maximum MySQL Connections Beyond the Default Limit?. For more information, please follow other related articles on the PHP Chinese website!