MariaDB enable event scheduler

MariaDb

The event scheduler is very useful when some tables should be archived or purged periodically.

Check if the even scheduler is running by executing:


SHOW PROCESSLIST;

Check if the event scheduler is turned on:


SHOW VARIABLES WHERE VARIABLE_NAME = 'event_scheduler'

If the event log scheduler is not listed, try this:


SET GLOBAL event_scheduler = ON;

Afterwards, check again if it is listed. Keep in mind that the event scheduler won't start up after restart unless you also specify it in the my.ini file:


[mysqld]
...
event_scheduler = on

Post a Comment

Previous Post Next Post