不重启mysql,查询执行时间超长的SQLID,kill
show full processlist;
select concat('KILL ',id,';') from information_schema.processlist where command='Query';
不重启mysql,查询执行时间超长的SQLID,kill
show full processlist;
select concat('KILL ',id,';') from information_schema.processlist where command='Query';