MySQL maximum number of connections modified

After the MySQL database installation is complete, the default maximum number of connections is 100, general traffic slightly larger forum or website this number of connections is far from enough, there are two ways to increase the default MySQL connection number

Method One: Enter the MySQL installation directory to open the MySQL profile My.ini or my.cnf find max_connections, if there are modifications max_connections=1000, if not directly added after [mysqld]

Re-starting MySQL in the service (services MySQL restart)

Method Two: MySQL maximum number of connections by default is 100 client login: Mysql-uusername-ppassword

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

Displays the currently running query:mysql> show processlist

Show current status:mysql> show status

Exit Client:mysql> Exit

To view the maximum number of connections currently: Mysqladmin-uusername-ppassword variables

MySQL maximum number of connections modified