1.配置定时任务event开启:
mysql> alter event EVENT_RegionTrafficIndex on completion preserve enable;
Query OK, 0 rows affected2.配置定时任务event关闭:
mysql> alter event EVENT_RegionTrafficIndex on completion preserve disable;
Query OK, 0 rows affected
一般定时任务(event)查看sql:
查看Events:
1
2
3
4
|
mysql> show events\G
mysql>
SELECT
*
FROM
mysql.event;
mysql>
SELECT
*
FROM
information_schema.events;
|
查看Events是否开启:
1
2
|
mysql>
select
@@event_scheduler;
mysql> show variables
like
'event_scheduler'
;
|
开启Events方法:
1
2
3
|
mysql>
set
GLOBAL
event_scheduler=
ON
;
或
mysql>
set
GLOBAL
event_scheduler=1;
|