Active Connections on MySQL

Using a command

Option1

show status where variable_name = 'threads_connected';

Columns

• Variable_name: Name of the variable shown

• Value: Number of active connections

Rows

• One row: only one row is displayed

Option2

show processlist;

Columns

• Id: The connection identifier

• User: The MySQL user who issued the statement

• Host: Host name and client port of the client issuing the statement

• db: The default database (schema), if one is selected, otherwise NULL

• Command: The type of command the thread is executing

• Time: The time in seconds that the thread has been in its current state

• State: An action, event, or state that indicates what the thread is doing

• Info: The statement the thread is executing, or NULL if it is not executing any statement

Using Query

Option3

select id,
       user,
       host,
       db,
       command,
       time,
       state,
       info
from information_schema.processlist;

Columns

• Id - The connection identifier

• User - The MySQL user who issued the statement

• Host - Host name and client port of the client issuing the statement

• db - The default database (schema), if one is selected, otherwise NULL

• Command - The type of command the thread is executing

• Time - The time in seconds that the thread has been in its current state

• State - An action, event, or state that indicates what the thread is doing

• Info - The statement the thread is executing, or NULL if it is not executing any statement

Rows

• One row: represents one active connection

• Scope of rows: total of active connections

Reference

List sessions / active connections on MySQL server - MySQL Data Dictionary Queriesdataedo