How to modify the maximum number of connections in mysql in linux

Method: 1. Use "set GLOBAL max_connections=number of links" to temporarily modify the maximum number of connections; 2. Use "vim /etc/my.cnf1" to modify the content of "max_connections", save and restart mysql service to permanently modify the maximum number of connections.

The operating environment of this tutorial: linux7.3 system, mysql8.0.22 version, Dell G3 computer.

How to modify the maximum number of mysql connections in Linux

Method 1: Temporary modification

Client login:

mysql -uroot -p

Set new The maximum number of connections is 1000:

mysql> set GLOBAL max_connections=1000

Display the currently running Query:

mysql> show processlist

Display the current status:

mysql> show status

Exit the client:

mysql> exit

View Current maximum number of connections:

mysqladmin -uroot -p variables

This method treats the symptoms but not the root cause. After restarting the service, the maximum number of connections is still 100. This method is used for emergency expansion of the maximum number of connections and is not a long-term solution.

Method 2: Permanent modification

View configuration file location

/usr/bin/mysql --verbose --help | grep -A 1 'Default optio

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

The server will first read the /etc/my.cnf file, if it does not exist Then read /etc/mysql/my.cnf, and then read /usr/etc/my.cnf and ~/.my.cnf

Look for the configuration file in the root path:

find / -name my.cnf
结果：/etc/my.cnf

Configuration

vim /etc/my.cnf

Edit my.cnf and add in [mysqld]:

max_connections=1000

Restart the service

service mysqld restart

View the number of connections

mysql -u root -p
show variables like 'max_connections';

Recommended learning: mysql video tutorial、Linux video tutorial

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