Xem biến Threads_connected = số kết nối đang mở.
Cách 1: SHOW STATUS
mysql> SHOW STATUS WHERE Variable_Name = 'Threads_connected';
+-------------------+-------+ | Variable_Name | Value | +-------------------+-------+ | Threads_connected | 1 | +-------------------+-------+ 1 row in set (0.06 sec)
Cách 2: SHOW PROCESSLIST
mysql> SHOW PROCESSLIST;
+----+-----------------+-----------------+----------+---------+--------+------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------------+----------+---------+--------+------------------------+------------------+ | 4 | event_scheduler | localhost | NULL | Daemon | 349012 | Waiting on empty queue | NULL | | 11 | root | localhost:54746 | business | Query | 1 | starting | show processlist | +----+-----------------+-----------------+----------+---------+--------+------------------------+------------------+ 2 rows in set (0.31 sec)
2 tiến trình: 1 daemon (event_scheduler), 1 query của root.