Description of MySQL scheduled task (event scheduler) EventScheduler _ MySQL

Description of MySQL scheduled task (event scheduler) EventScheduler bitsCN.com

To check whether the event scheduler is enabled, run the following SQL statement:

Show variables like 'event _ schedount ';
Or

SELECT @ event_scheduler;
Or

Show processlist;
If:

+ ----------------- + ------- +
| Variable_name | Value |
+ ----------------- + ------- +
| Event_scheduler | OFF |
+ ----------------- + ------- +
Then it can be executed

Set global event_scheduler = 1;
Or

Set global event_scheduler = ON;
You can also directly add"