MySQL for Windows modifies the maximum number of connections

1. Download and install MySQL Installer from official website. MySQL Installer provides an easy-to-use, guided installation experience for MySQL software (currently only available in Windows), and includes products such as:

MySQL Server, all connectors,workbench and sample models, sample databases, documentation. : http://dev.mysql.com/downloads/windows/installer/

Click the Download button under Mysql-installer-community-5.6.26.0.msi, click No Thanks in the jump page , just start my Download. Can

2, start and all programs, MySQL--MySQL Server 5.6-MySQL 5.6 Command line Client

Enter Password: ( Enter the root account password, return )

Mysql> Show variables like '%max_connections% ';
+-----------------+-------+
| variable_name | Value |
+-----------------+-------+
| max_connections | 151 |
+-----------------+-------+
1 row in Set (0.00 sec)

The default number of connections is too small, in the actual application process needs to modify its maximum number of connections, from the source mysqld.cc file to learn that the maximum number of MySQL support connection is 16384, reference article: http://www.jb51.net/article/51829.htm

Modify method One:

Mysql> Set GLOBAL max_connections = 10000;

Query OK, 0 rows Affected (0.00 sec)

Modify method Two:

Open C:\ProgramData\MySQL\MySQL Server 5.6 under My.ini, modify [Mysqld] under max_connections = 10000, save and exit, restart the system

MySQL for Windows modifies the maximum number of connections