查看当前计划任务:
选择数据库后
查看是否开启计划任务:
- show global variables like '%event_scheduler%';
启动计划任务:
- set global event_scheduler = on
mysql自动启动计划任务:
编辑/etc/my.cnf文件,在[mysqld]下添加event_scheduler=1
- vi my.cnf
-
- 修改
-
- [mysqld]
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- user=mysql
- # Disabling symbolic-links is recommended to prevent assorted security risks
- symbolic-links=0
- event_scheduler=1
创建计划任务:
- CREATE
- DEFINER = 'root'@'192.168.0.1%'
- EVENT hxl.e_test
- ON SCHEDULE EVERY '1' MINUTE
- STARTS '2016-03-07 14:18:03'
- ON COMPLETION PRESERVE
- DO
- call sp_mytest()
-
- --每分钟执行一次