mysql定时任务

1、打开定时任务

SET GLOBAL event_scheduler = ON;

[mysqld]

event_scheduler = ON

2、创建、查询、删除定时任务

create event IF NOT EXISTS e_set_max_allowed_packet
ON SCHEDULE EVERY 10 SECOND DO 
set global max_allowed_packet=11534336;

select * from mysql.event

drop event if exists e_set_max_allowed_packet;

3、帮助网址

http://blog.csdn.net/mer1234567/article/details/7514855