Mysql 查看进程SQL

SELECT * FROM information_schema.PROCESSLIST
WHERE info IS NOT NULL
ORDER BY TIME desc,state,INFO;

SELECT CONCAT('kill ',id,';') AS KillSQL FROM information_schema.PROCESSLIST WHERE info LIKE 
'%from /*[Article_List]*/%' 
and time>10;
posted on 2012-12-13 14:33  思静  阅读(2428)  评论(0编辑  收藏  举报