56,687
社区成员
发帖
与我相关
我的任务
分享
mysql> show processlist;
+——–+——–+—————–+——+———+——+——-+——————+
| Id | User | Host | db | Command | Time | State | Info |
+——–+——–+—————–+——+———+——+——-+——————+
| 277801 | mydbuser | localhost:35558| mydb | Sleep | 1 | | NULL |
| 277804 | mydbuser | localhost:35561| mydb | Sleep | 1 | | NULL |
| 277805 | mydbuser | localhost:35562| mydb | Sleep | 0 | | NULL |
+——–+——–+—————–+——+———+——+——-+——————+
mysql> show processlist;
+--------+------+-----------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------------+------+---------+------+-------+------------------+
| 601258 | root | localhost:55207 | NULL | Query | 0 | NULL | show processlist |
+--------+------+-----------------+------+---------+------+-------+------------------+
+--------+------+------------------+------+-------------+--------+----------------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+------------------+------+-------------+--------+----------------------------------------------------------------+------------------+
| 2449 | ruser | 192.168.0.13:56841 | NULL | Binlog Dump | 246371 | Has sent all binlog to slave; waiting for binlog to be updated | NULL |
| 531488 | ruser | 192.168.0.13:46220 | NULL | Query | 0 | NULL | show processlist |
+--------+------+------------------+------+-------------+--------+----------------------------------------------------------------+------------------+