可以查看当前时间访问库的所有请求SQL
SELECT COUNT(*) AS c,state,info FROM `information_schema`.processlist GROUP BY state ORDER BY c DESC;
SHOW PROCESSLIST;
-- 查所有db库连接数
SELECT db,COUNT(db) FROM information_schema.`PROCESSLIST` GROUP BY db
mysql
查询慢SQL
原文：http://www.cnblogs.com/minily/p/7391179.html
