MySQL connection number is too small, resulting in site error Mysql:too many connections

2017.9.14

A site pre-launch stress test

Page Open Error Mysql:too many connections

A look at the MySQL connection number is set too small caused by

Enter MySQL to view the number of connections settings

Show variables like '%max_connections% ';

Only 151, how can, decisively decide to raise to 1000

PS: Server performance Yes, haha

Open MySQL config file my.cnf add max_connections=1000 to restart MySQL. Test again, no problem!

Method Two: The command line is temporarily modified. Set global max_connections=1000. This method is set only after the current process is valid, and once restarted, it reverts to its original state.

MySQL connection number is too small, resulting in site error Mysql:too many connections