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

ClearingThread is terminating.
InitializedThread has be initialized.
Waiting for next activationThe event queue contains items, but the next activation is at some time in the future.
Waiting for scheduler to stopWaiting for the event scheduler to stop after issuing SET GLOBAL event_scheduler=OFF.
Waiting on empty queueSleeping, as the event scheduler's queue is empty.


Comments loading...
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.