Mysql定时器的简单使用

SHOW VARIABLES LIKE 'event_scheduler';

SET GLOBAL event_scheduler = ON;

DELIMITER $$
DROP EVENT IF EXISTS deleteFrameInfo;
CREATE EVENT deleteFrameInfo
ON SCHEDULE EVERY 3 HOUR
STARTS '2021-5-1 00:00:00'
ON COMPLETION PRESERVE
DO BEGIN
DELETE from schedule_job_log where TIMESTAMPDIFF(MINUTE,create_date,NOW())>180;
END$$
DELIMITER;

select * from mysql.event;