mysql schedule job



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