MySQL show processlist说明
mysql> show processlist;+----+------+--------------------+------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time| State | Info |
+----+------+--------------------+------+---------+-------+-------+------------------+
|1 | root | localhost | NULL | Sleep | 12 | | NULL |
|2 | root | 192.168.100.1:7437 | test | Sleep |8035 | | NULL |
|3 | root | 192.168.100.1:7438 | NULL | Sleep | 24348 | | NULL |
|5 | root | 192.168.100.1:7443 | NULL | Sleep | 24317 | | NULL |
|7 | root | 192.168.100.1:7450 | test | Sleep | 24272 | | NULL |
|9 | root | 192.168.100.1:5152 | test | Query | 0 | init| show processlist |
+----+------+--------------------+------+---------+-------+-------+------------------+6 rows in set
mysql> show full processlist;
+----+------+--------------------+------+---------+-------+-------+-----------------------+
| Id | User | Host | db | Command | Time| State | Info |
+----+------+--------------------+------+---------+-------+-------+-----------------------+
|1 | root | localhost | NULL | Sleep | 19 | | NULL |
|2 | root | 192.168.100.1:7437 | test | Sleep |8042 | | NULL |
|3 | root | 192.168.100.1:7438 | NULL | Sleep | 24355 | | NULL |
|5 | root | 192.168.100.1:7443 | NULL | Sleep | 24324 | | NULL |
|7 | root | 192.168.100.1:7450 | test | Sleep | 24279 | | NULL |
|9 | root | 192.168.100.1:5152 | test | Query | 0 | init| show full processlist |
+----+------+--------------------+------+---------+-------+-------+-----------------------+6 rows in set
页:
[1]