시스템, 서버/Tip & Tech

mysql scheduler / 스케쥴러

용병 2016. 12. 15. 11:44

http://bizadmin.tistory.com/entry/mysql-%EC%9D%B4%EB%B2%A4%ED%8A%B8-%EC%8A%A4%EC%BC%80%EC%A5%B4%EB%9F%AC-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0


http://genesis8.tistory.com/298


http://ellehu.com/mysql/4225



example :: every day at 13:00

CREATE EVENT IF NOT EXISTS `session_cleaner_event`
ON SCHEDULE
  EVERY 13 DAY_HOUR
  COMMENT 'Clean up sessions at 13:00 daily!'
  DO
    DELETE FROM site_activity.sessions;


CREATE EVENT event1
ON SCHEDULE EVERY '1' DAY
STARTS '2016-12-15 13:00:00' -- should be in the future
DO
-- your statements
END