MySQL event not triggering

Question

I've created the following event, but for some reason it's not getting triggered:

CREATE EVENT Del_logs
ON SCHEDULE EVERY 1 HOUR
DO
    TRUNCATE TABLE security.errors;

Is there any log I could check to see what went wrong?

Answer 1

It looks like the event scheduler is OFF.

• use SHOW PROCESSLIST to check if the event scheduler is enabled. If it's ON you should see a process "Daemon" by user "event_scheduler".

• use

  SET GLOBAL event_scheduler = ON;
  

  to enable the scheduler if it's currently not enabled.

• More on configuring event scheduler read here