Check The Number Of MySQL Open Database Connections on Linux Or Unix-like Server

February 4, 2023 by Rahul Sahu

To check the number of open database connections in MySQL on a Linux or Unix-like server, you can use the following command:

mysqladmin status | grep "Threads_connected"

Alternatively, you can also use the following SQL query to check the number of open connections in MySQL:

SHOW STATUS WHERE `variable_name` = 'Threads_connected';

Both of these methods will return the number of currently open connections to the MySQL server.