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.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.