Use the mysql event scheduler to regularly delete binlog_MySQL

Use the mysql event scheduler to regularly delete binlog bitsCN. the event scheduler of comMySQL can execute a task accurately every second. it is suitable for applications with high real-time data requirements (such as stocks, odds, and scores.
First, check whether this function is enabled:
SELECT @ event_scheduler;
Before using this function, make sure that event_scheduler is enabled. you can execute:
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.
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:
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