mysql计划任务

灭掉慢查询的存储过程 

delimiter //
DROP PROCEDURE IF EXISTS kill_low_query;
create PROCEDURE kill_low_query()
BEGIN
DECLARE processid INT;
DECLARE done INT DEFAULT 0;
DECLARE cur CURSOR FOR SELECT id from information_schema.`PROCESSLIST`  where time > 30 and db = 'emuserndb' ;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN cur;
REPEAT
FETCH cur INTO processid;
IF processid THEN
KILL QUERY processid;
END IF;

UNTIL done END REPEAT;
CLOSE cur;
   
END
//

mysql的计划任务（每30秒执行一次）

CREATE EVENT event_kill_low_query ON SCHEDULE EVERY 30 SECOND 

DO CALL kill_low_query();