[MySQL] processlistをgrep ref: http://qiita.com/kidachi_/items/29805f589d0b365665da

file0.txt

mysql> show processlist;
+----+------+-----------+-------------+---------+------+-------+-----------------------+
| Id | User | Host      | db          | Command | Time | State | Info                  |
+----+------+-----------+-------------+---------+------+-------+-----------------------+
|  1 | root | localhost | foo_dev     | Sleep   | 3737 |       | NULL                  |
|  3 | root | localhost | bar_dev     | Query   |    0 | init  | show full processlist |
+----+------+-----------+-------------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec)

file1.txt

 $ mysqladmin -uroot -hyyyy -pxxxx processlist

file2.txt

 $ mysqladmin -uroot -hxxxx -pyyyy processlist
+----+------+-----------+-----------+---------+------+-------+------------------+
| Id | User | Host      | db        | Command | Time | State | Info             |
+----+------+-----------+-----------+---------+------+-------+------------------+
| 1  | root | localhost | foo_dev   | Sleep   | 3770 |       |                  |
| 6  | root | localhost |           | Query   | 0    | init  | show processlist |
+----+------+-----------+-----------+---------+------+-------+------------------+

file3.txt

 $ mysqladmin -uroot -hxxxx -pyyyyy processlist |grep localhost |grep -v processlist
| 1  | root | localhost | foo_dev   | Sleep   | 4095 |       |                  |