Set maximum number of connections in MySQL

MySQL sets maximum number of connections during installation, but sometimes we need to modify the value to meet our need.

Temporary measure

Restart the original settings after restarting MySQL.

# Enter in the context of MySQL connection
set GLOBAL max_connections=max_value;

Permanent measure

Modify the configuration of MySQL.

1. Find the ‘my.ini’‘ file in MySQL directory.

2. Modify the value of ‘max_connections‘.

3. Restart the MySQL.

References

mysql最大连接数设置技巧总结