復制代碼 代碼如下:

SELECT @@event_scheduler;

復制代碼 代碼如下:

SET GLOBAL event_scheduler = 1;

復制代碼 代碼如下:

CREATE EVENT purge_binlog ON SCHEDULE EVERY 1 DAY DO PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 4 DAY);

復制代碼 代碼如下:

SELECT *  FROM information_schema.EVENTS;