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

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?