-- 首先进入linux下的mysql命令行界面里.如,/usr/bin/mysql -- 使用less查看结果 pager less -- 恢复stdout pager -- 不输出内容 pager cat > /dev/null -- 返回结果的md5检验码 pager md5sum -- 更多如: pager grep Sleep | wc -l show processlist; pager awk -F '|' '{print $6}' | sort | uniq -c | sort -r show processlist; SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND='Sleep'; SELECT COMMAND,COUNT(*) TOTAL FROM INFORMATION_SCHEMA.PROCESSLIST GROUP BY COMMAND ORDER BY TOTAL DESC;