Shulou(Shulou.com)06/01 Report--

Editor to share with you mysql to view the current number of connections, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Mysql's way to see the current number of connections: you can view the current number of connections by executing the [show status like 'Threads%'] statement.

In MySQL, after the connection is established, a thread is assigned responsibility. A connection is a thread.

You can view the current number of connections by looking at the MySQL status parameters:

Mysql > show status like 'Threads%' +-+-+ | Variable_name | Value | +-+-+ | Threads_cached | 9 | Threads_connected | 1 | Threads_created | 3911 | | Threads_running | 1 | +-- -+ 4 rows in set (0.00 sec)

Where Threads_connected is the current number of connections.

The above is all the contents of mysql's method of checking the current number of connections. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.