MySQL 及 MariaDB 要檢視已開啟的連線數目, 可以用 MySQL 的 “show status” 指令查詢。
“show status” 會顯示 MySQL 執行時的一系統狀態, 其中也包括了已開啟連線數目。
首先登入 MySQL / MariaDB:
$ mysql -u root -p
Enter password:
Enter password:
登入 MySQL / MariaDB 後, 輸入以下指令:
1 2 3 4 5 6 7 |
show status like '%connected'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | Threads_connected | 1 | +-------------------+-------+ 1 row in set (0.00 sec) |
從上面可以看到, 已開啟的連線數是 1.
另一個方法是查看 MySQL processlist:
1 2 3 4 5 6 7 |
show processlist; +--------+--------+-----------+------+---------+------+-------+------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +--------+--------+-----------+------+---------+------+-------+------------------+----------+ | 181357 | phpini | localhost | NULL | Query | 0 | NULL | show processlist | 0.000 | +--------+--------+-----------+------+---------+------+-------+------------------+----------+ 1 row in set (0.00 sec) |
上面回傳一筆資料 (1 row in set), 即已開啟的連線數是 1.