In fact, the MySQL event scheduler is a process that runs in the background and is constantly looking for events to execute. But before we create or schedule an event, we just need to start the scheduler. It can be started with the help of the following statement -
mysql> SET GLOBAL event_scheduler = ON; Query OK, 0 rows affected (0.07 sec)
Now with the help of the following statement we can check its status in the MySQL process list -
mysql> SHOW PROCESSLIST\G
*************************** 1. row ***************************
Id: 3
User: root
Host: localhost:49500
db: query
Command: Query
Time: 0
State: starting
Info: SHOW PROCESSLIST
*************************** 2. row ***************************
Id: 4
User: event_scheduler
Host: localhost
db: NULL
Command: Daemon
Time: 11
State: Waiting on empty queue
Info: NULL
2 rows in set (0.06 sec)It can be shut down by the following statement -
mysql> SET GLOBAL event_scheduler = OFF; Query OK, 0 rows affected (0.07 sec)
The above is the detailed content of How do we start the MySQL event dispatcher?. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
