MySQL 5.1 with Maria Reference Manual :: 12 SQL Statement Syntax :: 12.5 Database Administration Statements :: 12.5.5 SHOW Syntax :: 12.5.5.34 SHOW SCHEDULER STATUS Syntax
Section Navigation [Toggle]
- 12.5.5 SHOW Syntax
- 12.5.5.1 SHOW AUTHORS Syntax
- 12.5.5.2 SHOW BINARY LOGS Syntax
- 12.5.5.3 SHOW BINLOG EVENTS Syntax
- 12.5.5.4 SHOW CHARACTER SET Syntax
- 12.5.5.5 SHOW COLLATION Syntax
- 12.5.5.6 SHOW COLUMNS Syntax
- 12.5.5.7 SHOW CONTRIBUTORS Syntax
- 12.5.5.8 SHOW CREATE DATABASE Syntax
- 12.5.5.9 SHOW CREATE EVENT Syntax
- 12.5.5.10 SHOW CREATE FUNCTION Syntax
- 12.5.5.11 SHOW CREATE PROCEDURE Syntax
- 12.5.5.12 SHOW CREATE TABLE Syntax
- 12.5.5.13 SHOW CREATE TRIGGER Syntax
- 12.5.5.14 SHOW CREATE VIEW Syntax
- 12.5.5.15 SHOW DATABASES Syntax
- 12.5.5.16 SHOW ENGINE Syntax
- 12.5.5.17 SHOW ENGINES Syntax
- 12.5.5.18 SHOW ERRORS Syntax
- 12.5.5.19 SHOW EVENTS Syntax
- 12.5.5.20 SHOW FUNCTION CODE Syntax
- 12.5.5.21 SHOW FUNCTION STATUS Syntax
- 12.5.5.22 SHOW GRANTS Syntax
- 12.5.5.23 SHOW INDEX Syntax
- 12.5.5.24 SHOW INNODB STATUS Syntax
- 12.5.5.25 SHOW MASTER STATUS Syntax
- 12.5.5.26 SHOW OPEN TABLES Syntax
- 12.5.5.27 SHOW PLUGINS Syntax
- 12.5.5.28 SHOW PRIVILEGES Syntax
- 12.5.5.29 SHOW PROCEDURE CODE Syntax
- 12.5.5.30 SHOW PROCEDURE STATUS Syntax
- 12.5.5.31 SHOW PROCESSLIST Syntax
- 12.5.5.32 SHOW PROFILE Syntax
- 12.5.5.33 SHOW PROFILES Syntax
- 12.5.5.34 SHOW SCHEDULER STATUS Syntax
- 12.5.5.35 SHOW SLAVE HOSTS Syntax
- 12.5.5.36 SHOW SLAVE STATUS Syntax
- 12.5.5.37 SHOW STATUS Syntax
- 12.5.5.38 SHOW TABLE STATUS Syntax
- 12.5.5.39 SHOW TABLES Syntax
- 12.5.5.40 SHOW TRIGGERS Syntax
- 12.5.5.41 SHOW VARIABLES Syntax
- 12.5.5.42 SHOW WARNINGS Syntax
SHOW SCHEDULER STATUS
This statement provides debugging information regarding the
Event Scheduler's state. It is supported only in
-debug builds of MySQL 5.1.11, and was
removed in 5.1.12 and subsequent releases.
Sample output is shown here:
+--------------------------------+---------------------+ | Name | Value | +--------------------------------+---------------------+ | scheduler state | INITIALIZED | | thread_id | NULL | | scheduler last locked at | init_scheduler::313 | | scheduler last unlocked at | init_scheduler::318 | | scheduler waiting on condition | 0 | | scheduler workers count | 0 | | scheduler executed events | 0 | | scheduler data locked | 0 | | queue element count | 1 | | queue data locked | 0 | | queue data attempting lock | 0 | | queue last locked at | create_event::218 | | queue last unlocked at | create_event::222 | | queue last attempted lock at | ::0 | | queue waiting on condition | 0 | | next activation at | 0-00-00 00:00:00 | +--------------------------------+---------------------+
In MySQL 5.1.12 and later, this information can be obtained using mysqladmin debug. (See Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”.) For more information about obtaining Event Scheduler status information, see Section 18.4.5, “Event Scheduler Status”.
User Comments
Add your own comment.