查詢連線數
mysqladmin -u root -p -h127.0.0.1 status
Threads 就是連線數 Uptime: 168765 Threads: 3 Questions: 2265 Slow queries: 0 Opens: 394 Flush tables: 2 Open tables: 250 Queries per second avg: 0.013
mysql>show full processlist
+----+-----------------+-----------------+------+---------+--------+------------------------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------------+------+---------+--------+------------------------+-----------------------+ | 4 | event_scheduler | localhost | NULL | Daemon | 169192 | Waiting on empty queue | NULL | | 16 | root | localhost:56512 | live | Sleep | 23923 | | NULL | | 18 | root | localhost | NULL | Query | 0 | starting | show full processlist | +----+-----------------+-----------------+------+---------+--------+------------------------+-----------------------+
沒有留言:
張貼留言