mysql定时事件设置

//查看数据表包含字段
desc netrelay;

//查看事件调度器是否开启
SHOW VARIABLES LIKE 'event_scheduler';

//临时开启事件调度器
SET GLOBAL event_scheduler = ON;

//持久化开启事件调度器
my.cnf中添加如下配置：
event_scheduler=on

//每十秒钟检查一次是否有数据满足条件(保留600s数据)
CREATE EVENT myevent ON SCHEDULE
EVERY 10 SECOND
DO delete from netrelay where time< UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 600 SECOND));

//每十秒钟检查一次是否有数据满足条件(保留5天数据)
CREATE EVENT myevent ON SCHEDULE
EVERY 10 SECOND
DO delete from netrelay where time< UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 5 DAY));

//查看所有事件
show events;

//查看事件执行记录
select * from mysql.event;

//查看进程列表
show processlist;

//删除事件
drop event if exists eventName;

//查看数据库大小
select concat(round(sum(DATA_LENGTH/1024/1024),2),'M') from information_schema.tables;