Mysql event scheduler regularly deletes binlog_MySQL

Mysql event scheduler regularly deletes binlog bitsCN. the Event sched (Event sched) has been added to Mysql since comMySQL5.1.6. it can be used to regularly execute certain tasks, to replace the previously scheduled tasks that can only be executed by the Linux operating system. the MySQL event scheduler can execute one task exactly every second, it is suitable for applications that require high real-time data (such as stocks, odds, and scores.
First, check whether this function is enabled:
The code is as follows: SELECT @ event_scheduler;
Before using this function, make sure that event_scheduler is enabled. you can execute:
The code is as follows: set global event_scheduler = 1;
Or we can add event_scheduler = 1 to the my. cnf file.
Then, write an event to delete the binlog. set the daily check and delete the binlog file four days ago.
The code is as follows: create event purge_binlog on schedule every 1 day do purge master logs before DATE_SUB (NOW (), INTERVAL 4 DAY );
To view scheduled events, run the following statement:
The code is as follows: SELECT * FROM information_schema.EVENTS;
You can see the job information in the corresponding database. the LAST_EXECUTED field reflects the last execution time of the corresponding job. BitsCN.com