Skip navigation links
19.5 The Event Scheduler and MySQL Privileges »
Section Navigation      [Toggle]

19.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 項12.5.4.25. 「SHOW SCHEDULER STATUS 構文」.

    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 the mysqladmin debug (see 項7.9. 「mysqladmin — MySQL サーバの管理を行うクライアント」); 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