30 Ocak 2017 Pazartesi

Why does not MySQL event run?

The event scheduler may be on OFF position.

.: SQL command below can be used to see if the event scheduler is ON or OFF;

SHOW PROCESSLIST;
If there is no line that has a process "Daemon" by user "event_scheduler", it means that the event scheduler is OFF and should be activated in order that events can run.

.: The event scheduler can be activated with the SQL command;

SET GLOBAL event_scheduler = ON;

Hiç yorum yok:

Yorum Gönder