MYSQL导入/迁移后事件不执行

 

mysql迁移后事件不执行

查看数据库是否开启事件支持
mysql> show variables like 'event_scheduler';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+

或   select @@event_scheduler;

开启事件支持
set global event_scheduler = on;

查看现有的事件
select @@event_scheduler;
show processlist;

查看事件最后一次的执行时间
SELECT * FROM information_schema.EVENTS;
SELECT LAST_EXECUTED FROM information_schema.EVENTS;