Solve the MySQL error: Toomanyconnections

The following Error suddenly occurred when connecting to www.ithov.com: MySQLErrorMessage: CannotconnecttoMySQLserverSQL: Error: ToomanyconnectionsErrno.: 1040Clickheretoseekhelp. The number of connections exceeds the value set by MySQL.

Connection to the official website of the risk letter http://www.ithov.com suddenly showed the following Error: MySQL Error Message: Can not connect to MySQL server SQL: Error: Too connections Errno.: 1040 Click here to seek help. the number of connections exceeds the value set by MySQL.

The following error suddenly occurred when connecting to the official website of fengxin:

MySQL Error
Message: Can not connect to MySQL server
SQL:
Error: Too internal connections
Errno.: 1040
Click here to seek help.

The number of connections exceeds the value set by MySQL. It is related to max_connections and wait_timeout. The larger the value of wait_timeout, the longer the idle waiting time for the connection, which leads to the larger number of current connections.

Solution:

1. For VM users, contact the Space Provider to optimize MySQL configuration;

2. for independent host users, contact the server administrator to optimize the configuration of the MySQL server. For details, refer:

Modify the parameters in the MySQL configuration file (my. ini in Windows and my. cnf in Linux:

Max_connections = 1000
Wait_timeout = 5

If not, you can add it on your own. After modification, restart MySQL. If this error is reported frequently, perform overall server optimization.