mysql排他鎖，mysql任務計劃怎么定制_mysql計劃任務

查看當前計劃任務：

選擇數據庫后show?events;

查看是否開啟計劃任務：show?global?variables?like?'%event_scheduler%';

啟動計劃任務：

set?global?event_scheduler?=?on

mysql排他鎖。mysql自動啟動計劃任務：編輯/etc/my.cnf文件,在[mysqld]下添加event_scheduler=1

修改

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

sql定時任務，#?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

mysql常用api，ON?SCHEDULE?EVERY?'1'?MINUTE

STARTS?'2016-03-07?14:18:03'

ON?COMPLETION?PRESERVE

DO

call?sp_mytest()

--每分鐘執行一次