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

I‘m a new MySQL server user. My server is running on a CentOS Linux. How can I check the number of active MySQL connections on Linux based system?

You can use the following commands on Linux or Unix-like systems:[donotprint][/donotprint]

a) mysqladmin status command

b) MySQL show status command

c) netstat or ss commands

mysqladmin status command example

Open the terminal App or login to the remote server using ssh:


Type the following command to get a short status message from the MySQL server:

mysqladmin status
## OR ##
mysqladmin status -u root -p 
## OR ##
mysqladmin status -h -u root -p

Sample outputs:

Uptime: 691356  Threads: 5  Questions: 83237956  Slow queries: 102736  Opens: 3585  Flush tables: 1  Open tables: 1019  Queries per second avg: 120.398

MySQL show status command to see open database connections example

First, connect to the your mysql server:

mysql -u root -p

Type the following sql query to see the number of connection attempts to the MySQL server includes both failed and successful connection attempts:

mysql> show status like 'Conn%';

Sample outputs:

Fig.01: “show status like ‘Conn%’;” in action

You can use the following sql command to see the number of currently open connections at mysql> prompt:

mysql> show status like '%onn%';
| Variable_name            | Value   |
| Aborted_connects         | 7       |
| Connections              | 6304067 |
| Max_used_connections     | 85      |
| Ssl_client_connects      | 0       |
| Ssl_connect_renegotiates | 0       |
| Ssl_finished_connects    | 0       |
| Threads_connected        | 7       | <---- No of currently open connections 
7 rows in set (0.00 sec)

Use show processlist sql command to see the number of open connections

Type the following sql command at mysql> prompt to see the number of currently open connections:

mysql> show processlist;
| Id      | User       | Host              | db         | Command | Time | State | Info             |
| 6297128 | root       | localhost         | NULL       | Query   |    0 | NULL  | show processlist |
| 6308321 | faqwpblogu | | lesaibkfaq | Sleep   |    1 |       | NULL             |
| 6308323 | faqwpblogu | | lesaibkfaq | Sleep   |    0 |       | NULL             |
| 6308325 | faqwpblogu | | lesaibkfaq | Sleep   |    1 |       | NULL             |
| 6308326 | faqwpblogu | | lesaibkfaq | Sleep   |    0 |       | NULL             |
5 rows in set (0.00 sec)

The above output indicates four currently open connection for user called 'faqwpblogu' from app server located at and

MySQL show status sql command summary

I suggest that you read the following pages for more info:

  1. SHOW STATUS Syntax
  2. Server Status Variables

Use netstat or ss (Linux only) command to list open database connections

The syntax is as follows for netstat command or ss command:

netstat -nat | grep

This will just give you an overview. I suggest that you use above sql commands only.

Posted by: SXI ADMIN

The author is the creator of nixCraft and a seasoned sysadmin, DevOps engineer, and a trainer for the Linux operating system/Unix shell scripting. Get the latest tutorials on SysAdmin, Linux/Unix and open source topics via RSS/XML feed or weekly email newsletter.


How to KVM, QEMU start or stop virtual machine from command line (CLI)

KVM or Kernel Based Virtual Machine is a popular virtualization technology. It allows you to run virtual guest machines over a host machine. To start...

How to Docker backup Saving and restoring your volumes

Running a Docker volume backup First, we spin up a temporary container, and we mount the backup folder and the target Docker volume to this container....

How to Start and Enable Firewalld on CentOS 7

In this article, we discuss how to start and enable firewalld. It is highly recommended that you have a firewall protecting your server.Pre-Flight CheckThese...