DELIMITER //
CREATE EVENT kill_process
ON SCHEDULE EVERY 10 SECOND
Starts '2020-10-20 00:00:00'
ENDS '2021-10-20 00:00:00'
DO BEGIN
KILL QUERY
(
SELECT
ID
FROM
information_schema.processlist
WHERE 1=1
AND INFO LIKE '%YOUR_TABLE_NAME%' /*YOUR_TABLE_NAME*/
# AND TIME > 2500 /*MILISECOND*/
ORDER BY ID ASC
);
END //
DELIMITER ;
SHOW EVENTS;
SHOW FULL PROCESSLIST;
DROP EVENT kill_process;
SET GLOBAL event_scheduler = ON;
Software Developer

İlk Yorumu Siz Yapın