Too connector connections

The number of Too many ons connections exceeds the value set by MySQL, which 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.

Too connector connections

Error No.: 1040

Problem Analysis:

The number of connections exceeds the value set in the mysql tutorial. 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.

To c: windows Directory (winnt in windows 2000), find the my. ini file.

In the my. ini file, add
Set-variable = max_connections = 10000

Save modification and save the changes.
Restart mysql once.

 

Solution:

1. For VM users, contact the Space Provider to optimize the configuration of the mysql server;

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

Mysql 5.1 or more modification files

You can increase this value in main config file (e.g.,/etc/my. cnf) using this syntax:

[Mysqld]
Set-variable = max_connections = 250
Wait_timeout = 55 how long does the Code discard the connection?