Two tips teach you how to modify the maximum number of MYSQL connections

The following describes how to modify the maximum number of connections of MYSQL. For your reference, if you have encountered similar problems in this regard, I believe it will enlighten you.

After the MYSQL database is installed, the maximum number of connections in MYSQL is 100 by default. Generally, the number of connections in a forum or website with a slightly higher traffic is far from enough. There are two ways to increase the maximum number of connections in MYSQL by default.

Method 1: Go to the MYSQL installation directory and open the MYSQL configuration file my. ini or my. cnf to find max_connections = 100 and change it to max_connections = 1000 to restart MYSQL.

Method 2: the maximum number of connections to MySQL is 100 by default. Client Logon: mysql-uusername-ppassword

Set the maximum number of new MYSQL 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 maximum number of connections to MYSQL: mysqladmin-uusername-ppassword variables

MySQL primary key design principles

Advantages of MySQL partitioning

Mysql Stored Procedure FAQs

Example of creating a MySQL Stored Procedure

Use of mysql ifnull Functions