First page Back Continue Last page Image

Events need the System Scheduler to work

MySQL events are similar to a crontab job on Linux

MySQL Event Scheduler manages the schedule & execution of Events

MySQL Events can be very useful in many cases such as optimizing database tables, cleaning up logs, archiving data, or generating complex reports during off-peak time

SHOW VARIABLES LIKE 'event_scheduler'

You can verify the MySQL Scheduler is on with this command:

If you need to activate the scheduler it can be done with this command:

SET GLOBAL event_scheduler = ON