admin管理员组文章数量:1538980
设置MySQL
SHOW VARIABLES LIKE 'event_scheduler'; # 查看开关
SET GLOBAL event_scheduler = ON; #打开事件调度器
永久开启方法:myf中[mysqld]添加event_scheduler=on #重启服务
查看事件
SHOW EVENTS; # 其中 EVENT_DEFINITION字段为事件执行的sql语句
select EVENT_NAME,LAST_EXECUTED from information_schema.EVENTS;
DROP EVENT [IF EXISTS] event_name; #删除事件
每天定时清理 只保留最近30天数据table_name表
CREATE EVENT IF NOT EXISTS table_name ON SCHEDULE EVERY 1 DAY
STARTS concat(CURRENT_DATE,' 00:00:00')
DO
delete from table_name where timestamp < DATE_FORMAT( date_sub(curdate(),interval 30 day) ,'%Y-%m-%d');
三个表格设置不同的事件启动
CREATE EVENT IF NOT EXISTS repoissue_event ON SCHEDULE EVERY 1 DAY STARTS CONCAT(CURRENT_DATE, ' 22:20:00') DO DELETE FROM repoissue where timecheck < DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 30 DAY),'%Y%m%d');
CREATE EVENT IF NOT EXISTS langrepo_event ON SCHEDULE EVERY 1 DAY STARTS CONCAT(CURRENT_DATE, ' 22:50:00') DO DELETE FROM langrepo where timecheck < DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 30 DAY),'%Y%m%d');
CREATE EVENT IF NOT EXISTS lang_trend_weekly_event ON SCHEDULE EVERY 1 DAY STARTS CONCAT(CURRENT_DATE, ' 23:30:00') DO DELETE FROM language_trend_weekly where timecheck < DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 30 DAY),'%Y-%m-%d');
版权声明:本文标题:mysql定时清理数据 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/xitong/1726093375a1055212.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论