mysql开启事件调度失败_MySQL事件（Event）&任务调度无效解决办法

开启关闭事件调度器

MySQL事件调度器event_scheduler负责调用事件，它默认是关闭的。这个调度器不断地监视一个事件是否要调用， 要创建事件，必须打开调度器。

开启事件调度器

通过命令行 可通过如下任何一个命令行

SET GLOBAL event_scheduler = ON;

SET @@global.event_scheduler = ON;

SET GLOBAL event_scheduler = 1;

SET @@global.event_scheduler = 1;

通过配置文件my.cnf

event_scheduler = 1 #或者ON

查看调度器线程

mysql> show processlist;

+----+-----------------+-----------+------+---------+------+------------------------+------------------+

| Id | User | Host | db | Command | Time | State | Info |

+----+-----------------+-----------+------+---------+------+------------------------+------------------+

| 2 | root | localhost | NULL | Query | 0 | NULL | show processlist |

| 3 | event_scheduler | localhost | NULL | Daemon | 6 | Waiting on empty queue | NULL |

+----+-----------------+-----------+------+---------+------+------------------------+------------------+

关闭事件调度器

通过命令行可通过如下任何一个命令行

SET GLOBAL event_scheduler = OFF;

SET @@global.event_scheduler = OFF;

SET GLOBAL event_scheduler = 0;

SET @@global.event_scheduler = 0;

通过配置文件my.cnf在[mysqld]下增加

event_scheduler = 0 #或者OFF，DISABLED

查看调度器线程

mysql> show processlist;

+----+------+-----------+------+---------+------+-------+------------------+

| Id | User | Host | db | Command | Time | State | Info |

+----+------+-----------+------+---------+------+-------+------------------+

| 2 | root | localhost | NULL | Query | 0 | NULL | show processlist |