無料PHPプログラム

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