mysql event:
查看一下活动中的Event Scheduler: show processlist;
开启 Event Scheduler: set global event_scheduler=1;
mysql> show global variables like 'event_scheduler';
delimiter |
CREATE EVENT spider_weekly
ON SCHEDULE
EVERY 1 minute
COMMENT 'move spider_task_log to history'
DO
BEGIN
insert into A select * from B where modify_time < date_sub(now(), INTERVAL 7 day);
END |
delimiter ;
every 1 minute
every 1 hour
或者定时调用procedure
创建event
Create event ***
On schedule
Every 5 minute
Starts now()
Do
Begin
Call proc();
End
相关参考http://www.jb51.net/article/38319.htm