mysql 服务器启用event_scheduler
首先用:
SHOW VARIABLES LIKE 'event_scheduler'
查看event_scheduler的状态,如果是off 则需要开启
开启命令:
SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;
关闭event_scheduler命令:
SET GLOBAL event_scheduler = OFF;
SET @@global.event_scheduler = OFF;
SET GLOBAL event_scheduler = 0;
SET @@global.event_scheduler = 0;