#1、建立存儲過程供事件調(diào)用delimiter//drop procedure if exists middle_proce//create procedure middle_proce()beginDELETE FROM jg_bj_comit_log WHERE comit_time < SUBDATE(NOW(),INTERVAL 2 MONTH);optimize table jg_bj_comit_log;DELETE FROM jg_bj_order_create WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_order_create;DELETE FROM jg_bj_order_match WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_order_match;DELETE FROM jg_bj_order_cancel WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_order_cancel;DELETE FROM jg_bj_operate_arrive WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_operate_arrive;DELETE FROM jg_bj_operate_depart WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_operate_depart;DELETE FROM jg_bj_operate_login WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_operate_login;DELETE FROM jg_bj_operate_logout WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_operate_logout;DELETE FROM jg_bj_operate_pay WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_operate_pay;DELETE FROM jg_bj_position_driver WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_position_driver;DELETE FROM jg_bj_position_vehicle WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_position_vehicle;DELETE FROM jg_bj_rated_passenger WHERE created_on < SUBDATE(NOW(),INTERVAL 3 MONTH);optimize table jg_bj_rated_passenger;end//delimiter;#2、開啟event(要使定時起作用，MySQL的常量GlOBAL event_schduleer 必須為on 或者1)show variables like 'event_scheduler'set global event_scheduler='on'#3、創(chuàng)建Evnet事件drop event if exists middle_event;create event middle_eventon schedule every 1 DAY STARTS '2017-12-05 00:00:01'on completion preserve ENABLEdo call middle_proce();#4、開啟Event 事件alter event middle_event on completion preserve enable;#5、關(guān)閉Event 事件alter event middle_event on completion preserve disable;