Home  >  Article  >  Database  >  How to check the current number of mysql connections

How to check the current number of mysql connections

coldplay.xixi
coldplay.xixiOriginal
2020-09-28 10:19:0415755browse

How to check the current number of mysql connections: first connect to the database and enter the information; then create a new query window and enter the query statement; then click "Run" to query; finally [Threads_connected] is the number of connections.

How to check the current number of mysql connections

How to check the current number of mysql connections:

1. Use the database management tool and click "Connect" - "mysql"

How to check the current number of mysql connections

2. Enter the connection information of the mysql database, IP address, port number, user name, password and other information, and click OK to connect to the mysql database.

How to check the current number of mysql connections

#3. Click "Query" - "New Query" to create a new query window.

How to check the current number of mysql connections

4. In the query window, enter the query statement show status like 'Threads%'

How to check the current number of mysql connections

5. Click " Run" to perform the query, wait for the query to complete, and view the query results.

How to check the current number of mysql connections

#6. You can see the relevant information about 'Threads%' in the query results, where Threads_connected is the number of connections.

How to check the current number of mysql connections

More related free learning recommendations: mysql tutorial(Video )

The above is the detailed content of How to check the current number of mysql connections. 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