创建mysqlEvent:
CREATE EVENT translateEvent
ON SCHEDULE EVERY 2 MINUTE COMMENT 'Clears out sessions table each minute.' DO CALL crawlInternationalizationData();启用event_scheduler,运行时执行:
set global event_scheduler=on
要随MySQL服务一起启用,则在/etc/my.cnf中添加
[mysqld]event-scheduler=on