Home  >  Article  >  Database  >  Teach you how to modify the default maximum number of connections in mysql

Teach you how to modify the default maximum number of connections in mysql

怪我咯
怪我咯Original
2017-03-31 10:04:082026browse

mysql has a maximum number of connections, the default is 100

Teach you how to modify the default maximum number of connections in mysql
Modification method: enter the mysql terminal,
mysql > ; set GLOBAL max_connections=1000;
mysq > show variables like '%max_connections%';

Of course, you can also directly modify the mysqlconfiguration file. Enter the MySQL installation directory, open the MySQL configuration file my.ini or my.cnf, search for max_connections=100, change it to max_connections=1000, and restart MySQL in the service.
Note: The maximum number of connections allowed by the MySQL server is 16384


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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn