- 7.5.6 Examining Thread Information
- 7.5.6.1 Thread Command Values
- 7.5.6.2 General Thread States
- 7.5.6.3 Delayed-Insert Thread States
- 7.5.6.4 Query Cache Thread States
- 7.5.6.5 Replication Master Thread States
- 7.5.6.6 Replication Slave I/O Thread States
- 7.5.6.7 Replication Slave SQL Thread States
- 7.5.6.8 Replication Slave Connection Thread States
- 7.5.6.9 Event Scheduler Thread States
These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that terminate the scheduler.
-
The scheduler thread or a thread that was executing an event is terminating and is about to end.
-
The scheduler thread or a thread that will execute an event has been initialized.
-
The scheduler has a nonempty event queue but the next activation is in the future.
-
The thread issued
SET GLOBAL event_scheduler=OFFand is waiting for the scheduler to stop. -
The scheduler's event queue is empty and it is sleeping.
User Comments
Add your own comment.