This article documents thread states that are related to event scheduling and execution. These include the Event Scheduler thread, threads that terminate the Event Scheduler, and threads for executing events.
These correspond to the STATE values listed by the SHOW PROCESSLIST statement or in the Information Schema PROCESSLIST Table as well as the PROCESSLIST_STATE value listed in the Performance Schema threads Table
| Value | Description |
|---|---|
| Clearing | Thread is terminating. |
| Initialized | Thread has be initialized. |
| Waiting for next activation | The event queue contains items, but the next activation is at some time in the future. |
| Waiting for scheduler to stop | Waiting for the event scheduler to stop after issuing SET GLOBAL event_scheduler=OFF. |
| Waiting on empty queue | Sleeping, as the event scheduler's queue is empty. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/event-scheduler-thread-states/