Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to query the maximum number of connections of mysql". In daily operation, I believe many people have doubts about how to query the maximum number of connections of mysql. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how to query the maximum number of connections of mysql"! Next, please follow the editor to study!

In mysql, the "show variables like'% max_connections%';" command can be used to query the maximum number of connections to mysql; the show command is used to provide various forms to obtain database information, and "max_connections" is used to represent the maximum number of connections.

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How to query the maximum number of connections in mysql

The query command is:

Show variables like'% max_connections%'

The default maximum number of connections for MySQL is 100, which can be viewed on the mysql client using the above command

This command will get an output similar to the following:

+-- +-+ | Variable_name | Value | +-+-+ | max_connections | 1000 | | max_user_connections | 1000 | +-+-+

To change the maximum number of connections for mysql, simply change the value of max_connections in the my.cnf configuration file, and then restart mysql. If no max_connections entry is found in the my.ini file, you can add the following entry yourself

Max-connections = 1000max_user_connections = 1000

Just restart Mysql!

Examples are as follows:

At this point, the study on "how to query the maximum number of connections of mysql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.