The Event Scheduler (http://dev.mysql.com/doc/refman/5.1/en/events.html ), another new feature of MySQL 5.1, permits the creation of tasks that will run automatically according to a schedule. The schedule is quite flexible and permits, for example, a statement to be run every ten seconds, starting from midnight, May 18, 2011. These can be one-time events or recurring ones.
We should first verify whether the scheduler is active on our server. If not, we need to activate it. Otherwise, nothing will happen! We start by typing this statement in the query box:
SHOW VARIABLES LIKE 'event%';
Next, we look for a variable named
event_scheduler. If this variable is set to
OFF, we need to ask the system administrator ...