打开定时事件调度器,就会出现event_scheduler的守护进程
set global event_scheduler=1;
创建event
Create event ***
On schedule
Every 5 minute
Starts now()
Do
Begin
Call proc();
End
删除事件
drop event if exists event_name;
查看事件:
show events;
查看是否开启了自动执行:
show global variables like 'event_scheduler';
set global event_scheduler=on;
查看任务列表:
show processlist;
set global event_scheduler=1;
创建event
Create event ***
On schedule
Every 5 minute
Starts now()
Do
Begin
Call proc();
End
删除事件
drop event if exists event_name;
查看事件:
show events;
查看是否开启了自动执行:
show global variables like 'event_scheduler';
set global event_scheduler=on;
查看任务列表:
show processlist;