msyql show processlist

如果登陆的用户拥有super权限，，就可以看到所有连接到mysql的连接的状态。

mysql> show processlist ;
+----------+---------+----------------------+------+-------------+-------+----------------------------------------------------------------+------------------+
| Id       | User    | Host                 | db   | Command     | Time  | State                                                          | Info             |
+----------+---------+----------------------+------+-------------+-------+----------------------------------------------------------------+------------------+
| 41419293 | jw_sync | 172.24.224.28:45800  | NULL | Sleep       | 65190 |                                                                | NULL             | 
| 41419294 | jw_sync | 172.24.224.28:45801  | NULL | Binlog Dump | 65197 | Has sent all binlog to slave; waiting for binlog to be updated | NULL             | 
| 41486860 | jw_sync | 172.23.100.210:36396 | NULL | Query       |     0 | NULL                                                           | show processlist | 
+----------+---------+----------------------+------+-------------+-------+----------------------------------------------------------------+------------------+

其中Id就是个序列号，User列表示连接的用户名，Host表示连接的主机ip和端口，db，表示当前所在的db。Command

Sleep：表示等待client发送命令

Binlog Dump：binlog dump线程

Query：查询命令

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| dc_params_06       | 
| dc_params_07       | 
| mysql              | 
| test               | 
+--------------------+

change dabatase 后，看到db列变化了

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show processlist ;
+----------+---------+----------------------+------+-------------+-------+----------------------------------------------------------------+------------------+
| Id       | User    | Host                 | db   | Command     | Time  | State                                                          | Info             |
+----------+---------+----------------------+------+-------------+-------+----------------------------------------------------------------+------------------+
| 41419293 | jw_sync | 172.24.224.28:45800  | NULL | Sleep       | 65560 |                                                                | NULL             | 
| 41419294 | jw_sync | 172.24.224.28:45801  | NULL | Binlog Dump | 65567 | Has sent all binlog to slave; waiting for binlog to be updated | NULL             | 
| 41486860 | jw_sync | 172.23.100.210:36396 | test | Query       |     0 | NULL                                                           | show processlist | 
+----------+---------+----------------------+------+-------------+-------+----------------------------------------------------------------+------------------+