mysql事件不能正常执行

Question

我在mysql里制定了一个任务如下
mysql> create event DelEvent
    -> ON SCHEDULE EVERY 5 minute
    -> starts '2010-06-24 15:36:00'
    -> do
    -> delete from table where TO_DAYS(NOW()) - TO_DAYS(collectdate)>=750;
Query OK, 0 rows affected (0.00 sec)
但是时间到了后根本不执行，请问是为什么啊
事件任务已打开
mysql> show variables like '%sche%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| event_scheduler | ON    | 
+-----------------+-------+
1 row in set (0.00 sec)

Answer 1

show events;贴出来看一下。

Answer 2

mysql> show events;
+-------+----------+----------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
| Db    | Name     | Definer        | Time zone | Type      | Execute at | Interval value | Interval field | Starts              | Ends | Status  | Originator | character_set_client | collation_connection | Database Collation |
+-------+----------+----------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
| itm22 | DelEvent | root@localhost | SYSTEM    | RECURRING | NULL       | 5              | MINUTE         | 2010-06-24 16:16:00 | NULL | ENABLED |          0 | latin1               | latin1_swedish_ci    | latin1_swedish_ci  | 
+-------+----------+----------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
1 row in set (0.00 sec)

Answer 3

我后来修改过事件的执行时间了，所以会出现show envents里的事件和刚才贴出来创建时候的时间不一样的情况