- /usr/local/mysql/bin/mysql -uroot -p'mypass' -S/tmp/mysql.sock -e "show processlist;"
执行结果:
+--------+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------+------+---------+------+-------+------------------+
| 179830 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+--------+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------+------+---------+------+-------+------------------+
| 179830 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+--------+------+-----------+------+---------+------+-------+------------------+
本文转自holy2009 51CTO博客,原文链接:http://blog.51cto.com/holy2010/343934