Shulou(Shulou.com)06/01 Report--

This article will explain in detail about the mysql database prompt connection too many solutions, the editor thinks it is very practical, so share it for you to do a reference, I hope you can get something after reading this article.

Mysql database prompts solutions for too many connections: 1, log in to the mysql database to view the value of the currently active connection thread; 2, edit the my.cnf configuration file and add [[mysqld] port=3306]; 3, restart the mysql server.

Solution:

View max_connections

Enter MySQL and use the command:

$show variables

View the variable value of the maximum number of connections to the database: max_connections

View threads_connected

Enter MySQL and use the command:

$show status

View the value of the currently active connection thread variable: threads_connected

To set up max_connections, in the my.cnf file, add the following last line:

Copy

[mysqld] port=3306 # socket=MySQL... set-variable = max_connections=32000

After the modification, restart MySQL. Of course, to make sure the settings are correct, you should take a look at max_connections.

Note:

1. Although 32000 is written here. But the maximum number of connections allowed by the actual MySQL server is 16384

2. In addition to max_connections, the other configurations mentioned above should be configured according to the needs of your system.

3. The maximum number of allowable connections is added, which does not increase the consumption of the system.

4. If your mysql uses my.ini as the configuration file, the setting is similar, but the format should be slightly modified.

About the mysql database prompt connection too many solutions to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.