Shulou(Shulou.com)06/03 Report--

The following is about how to delete out-of-date mysql data. The secret of the text is that it is close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on how to delete mysql expired data.

1. Check whether MySQL has enabled the event function.

View commands:

Show variables like'% sc%'

Open event_scheduler (temporarily open, and expire after restart of MySQL service)

SET GLOBAL event_scheduler = ON

How to enable it permanently: [mysqld] add event_scheduler=on # to restart the service in my.cnf

2. Create an event

Create event myevent on SCHEDULE every 5 second do delete from Syslog.SystemEvents where ReceivedAt

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.