mysqldatabaseeventsschedulermysql-event

How to check event scheduler status in MySQL?


In MySQL, we can enable the event scheduler by following query:

SET GLOBAL event_scheduler = ON;

Similarly, to turn off the scheduler:

SET GLOBAL event_scheduler = OFF;

But, Is there any query/way to check the status of event_scheduler whether it's ON or OFF?


Solution

  • Use SHOW VARIABLES

    SHOW VARIABLES
    WHERE VARIABLE_NAME = 'event_scheduler'