show processlist;
show processlist\G;
SHOW FULL PROCESSLIST;
SHOW FULL PROCESSLIST\G;
REF:
http://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
http://stackoverflow.com/questions/568564/how-can-i-view-live-mysql-queries
How can I view currently running MySQL queries?（ 查看正在运行的MySQL语句/脚本命令）
原文：http://www.cnblogs.com/emanlee/p/5759245.html