在使用show processlist的时候，直接使用会显示很多的内容，无法很快找到需要的信息。
如何过滤操作呢？
其实，show processlist展示的内容是从information_schema.processlist数据表查询得到。
数据表information_schema.processlist各字段如下：
mysql> desc information_schema.processlist;
+---------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| ID | bigint(21) unsigned | NO | | 0 | |
| USER | varchar(32) | NO | | | |
| HOST | varchar(64) | NO | | | |
| DB | varchar(64) | YES | | NULL | |
| COMMAND | varchar(16) | NO | | | |
| TIME | int(7) | NO | | 0 | |
| STATE | varchar(64) | YES | | NULL | |
| INFO | longtext | YES | | NULL | |
+---------+---------------------+------+-----+---------+-------+
8 rows in set (0.04 sec)
所以可以使用SQL语句的条件查询进行过滤，例如:
>select * from information_schema.processlist where Host like '10.26.201.199%';
+---------+-------------+---------------------+------+---------+------+-------+------+---------+-----------+---------------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED |
+---------+-------------+---------------------+------+---------+------+-------+------+---------+-----------+---------------+
| 315835 | ora_manager | 10.26.201.199:45028 | NULL | Sleep | 2796 | | NULL | 2795673 | 1 | 0 |
| 1354509 | ora_manager | 10.26.201.199:53340 | NULL | Sleep | 976 | | NULL | 975677 | 1 | 0 |
| 240640 | ora_manager | 10.26.201.199:45802 | NULL | Sleep | 4 | | NULL | 3684 | 1 | 0 |
| 1354510 | ora_manager | 10.26.201.199:53342 | NULL | Sleep | 976 | | NULL | 975678 | 1 | 0 |
| 240641 | ora_manager | 10.26.201.199:45810 | NULL | Sleep | 4 | | NULL | 3687 | 1 | 0 |
| 315836 | ora_manager | 10.26.201.199:45032 | NULL | Sleep | 2796 | | NULL | 2795672 | 1 | 0 |
| 1354511 | ora_manager | 10.26.201.199:53344 | NULL | Sleep | 976 | | NULL | 975678 | 1 | 1103 |
| 315837 | ora_manager | 10.26.201.199:45030 | NULL | Sleep | 2796 | | NULL | 2795674 | 1 | 1103 |
| 240642 | ora_manager | 10.26.201.199:45812 | NULL | Sleep | 4 | | NULL | 3687 | 1 | 1103 |
+---------+-------------+---------------------+------+---------+------+-------+------+---------+-----------+---------------+
9 rows in set (0.00 sec)