MySQL optimization small case: number of connections

Error code: Mysql:error 1040:too Many connections

Often encounter this error, either business growth, normal traffic increase, or your own max_connections settings are too small

To view the maximum number of connections for a system max

mysql> SHOW VARIABLES like ' max_connections ';

　　

View the maximum number of connections processed before the system used

Mysql> SHOW GLOBAL STATUS like '%max_used_connections% ';

　　

General used/max≈80% is more ideal.

To set the size of a connection:

mysql> SET GLOBAL max_connections = 200; Query OK, 0 rows Affected (0.00 sec)

But after the reboot, it was dead. If the requirement is not changed, it can be modified in my.cnf.

MySQL optimization small case: number of connections