Trigger,触发器,针对的是数据库的表的事件,如update,insert,replace等
Event Scheduler,事件规划者,依据时间规划事件,如定时或固定间隔循环执行事件。
每10秒清理过期(超过60秒)数据demo如下:
0. 开启 event_scheduler功能,默认开启
SET GLOBAL event_scheduler = 1;
1. 创建存储过程del_outdate(),以提高效率:
CREATE PROCEDURE del_outdate()
delete * from tb_my where unix_timestamp()-mySecond>60;
2.创建Event Scheduler
CREATE EVENT clear_event
ON SCHEDULE EVERY 10 SECOND
DO del_outdate();
//指定时间则是"at 时间"
3.启动Event Scheduler
ALTER EVENT clear_event ON COMPLETION PRESERVE ENABLE;
*COMPLETION PRESERVE ,意为事件执行完成后仍保存