Skip navigation links

Additional languages
MySQL 5.1 Reference Manual :: 25 Event Scheduler :: 25.4 Event Scheduler Status
25.5 The Event Scheduler and MySQL Privileges »
Section Navigation      [Toggle]

25.4. Event Scheduler Status

Information about the state of the Event Scheduler for debugging and troubleshooting purposes can be obtained as follows:

  • In MySQL 5.1.11 -debug builds, you can use the SHOW SCHEDULER STATUS statement; see Section 12.5.5.26, “SHOW SCHEDULER STATUS Syntax”.

    Important

    This statement was removed in MySQL 5.1.12. We intend to implement an SQL statement providing similar functionality in a future MySQL release.

  • Beginning with MySQL 5.1.12, event scheduler status information can be obtained by running mysqladmin debug (see Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”); after running this command, the error log contains output relating to the Event Scheduler, similar to what is shown here: 

    Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked

Event scheduler status:
State      : INITIALIZED
Thread id  : 0
LLA        : init_scheduler:313
LUA        : init_scheduler:318
WOC        : NO
Workers    : 0
Executed   : 0
Data locked: NO

Event queue status:
Element count   : 1
Data locked     : NO
Attempting lock : NO
LLA             : init_queue:148
LUA             : init_queue:168
WOC             : NO
Next activation : 0000-00-00 00:00:00