How to modify the maximum number of connections in mysql

Modification method: 1. Execute the "set GLOBAL max_connections=connection value;" command. 2. Open the mysql configuration file "my.cnf", add the "max_connections=connection value" statement to the file, save the file and restart the service.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

The maximum number of connections can be modified through mysql. There are two commonly used methods to modify the maximum number of connections in mysql database. Today we will analyze the characteristics and differences between the two methods so that we can better To maintain mysql. Let's take a look at how to modify the maximum number of connections in MySQL. I hope the article can help everyone.

Problem

When using the MySQL database, we often encounter such a problem, which is "Can not connect to MySQL server. Too many connections”-mysql 1040 error, this is because the number of connections accessing MySQL that have not yet been released has reached the upper limit of MySQL. Usually, the default maximum number of connections for MySQL is 100, and the maximum number can reach 16384.

There are two commonly used ways to modify the maximum number of connections.

Solution 1: Use the command

to set the maximum number of connections through theset GLOBAL max_connections=100;command is 100, this method takes effect immediately and does not require restarting the mysql service.

It should be noted that, you need a mysql account with root permissions to operate, otherwise"1227 - Access denied; you need (at least one of) the SUPER privilege will be reported (s) for this operation"error.

At the same time, set the minimum value of max_connections to 1.

Solution 2: Modify my.cnf

Open the mysql configuration filevim /etc/my.cnf, add themax_connections=100 line(if there is one, just modify the value directly), and then restart the service:/etc/init.d/mysqld restart, it will take effect at this time.

Difference:

1. By modifying the configuration file, you need to restart the service; modifying it with a command will take effect immediately.

2. Modify the configuration file to make it more stable and reliable. Because if there ismax_connections=100in the configuration file, and then use the command to modify it, once the mysql service is restarted, the number of connections specified in the configuration file will be used again.

[Related recommendations:mysql video tutorial]

The above is the detailed content of How to modify the maximum number of connections in mysql. For more information, please follow other related articles on the PHP Chinese website!