A simple method to regularly delete expired data records in MySQL

1. After connecting and logging in to MySQL, first check whether the event function is enabled in MySQL:

Command: show variables like '%sc%';

It is found that event_sheduler is OFF;

2. Open event_scheuler:

Temporarily enabled (invalid after restarting MySQL service)

SET GLOBAL event_scheduler = ON; SET GLOBAL event_scheduler = 1; — 0 means off

Permanently open

Add the following content to the [mysqld] section in my.cnf, and then restart mysql (mysql restart command: service mysqld restart)

event_scheduler=ON

3. Create an event. Here is an example to delete data in the wififlows table that is 2 minutes old and expired every 5 seconds:

create event e_delete_wififlows on schedule every 5 seconds do delete from wififlows where timestamp < (CURRENT_TIMESTAMP() + INTERVAL -2 MINUTE);

If this event already exists, you can delete it using the following command:

drop event if exists e_delete_wififlows;

Then use show events; to view the existing events

4. Open the event:

alter event e_del_wififlows on completion preserve enable;

5. Close event:

alter event e_del_wififlowa on completion preserve disable;

The above simple method of regularly deleting expired data records in MySQL is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.