1. show processlist
查看mysql执行的查询情况
2.select * from information_schema.processlist where db='zcwdb' and state='Sending data';
3.select concat('kill ', id,';') from information_schema.processlist where db='zcwdb' and state='Sending data' and time > 500;