Two Methods for modifying the maximum number of connections of MYSQL in Windows

DocumentAfter the MYSQL database is installed, the default maximum number of connections is 100. Generally, the number of connections to forums or websites with a higher traffic is far from enough. There are two ways to increase the default number of connections to MYSQL.

The temporary method I use is as follows:

The maximum number of connections for MySQL is 100 by default. Client Logon: mysql-u username-p

Set the new maximum number of connections to 200: mysql> set GLOBAL max_connections = 200

Display the currently running Query: mysql> show processlist

Display Current status: mysql> show status

Exit the client: mysql> exit

View the current maximum number of connections: mysqladmin-u username-p password variables

The disadvantage of this method is that the modification fails after the server is restarted. It is best to use method 2 as follows:

Method 2: Go to the MYSQL installation directory and open the MYSQL configuration file my. ini or [mysqld] under my. cnf. Find max_connections = 100 and change it to max_connections = 1000 to restart MYSQL.