Event Scheduler Thread States
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.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?