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

This article will give you a detailed explanation on how to set the maximum number of connections in mysql. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

How to set the maximum number of mysql connections:

Method 1: modify the command line

We just need to open the console of mysql and enter the "set GLOBAL max_connections=1000;" statement to set the maximum number of connections directly, as shown in the following figure:

Note: this method does not address the root causes, and can only temporarily modify the maximum number of connections. If you restart mysql at one point, the maximum number of connections will return to the previously set value.

Method 2: modify the maximum number of connections through the mysql configuration file

1. Open the mysql installation directory on your computer and find the my.ini file, as shown in the following figure:

2. Open the my.ini file with notepad, and find and modify the value of "max_connections". The default maximum number of connections is 100, as shown in the following figure:

Set "max_connections=1000" so that you can set the maximum number of connections for mysql to 1000.

3. After setting the maximum number of connections, you need to restart the mysql service.

In [computer]-- > [Management]-- > [Services and applications]-- > [Services]-- > [MySQL]

Click mysql and right click to enable or close it, as shown in the following figure:

This sets the maximum number of mysql connections to 1000 and is permanently set.

This is the end of the article on "detailed explanation of how to set the maximum number of connections in mysql". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please 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.