How to check the current number of mysql connections

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:

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

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.

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

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

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

#6. You can see the relevant information about 'Threads%' in the query results, where Threads_connected is the number of 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!