mysqlのタイミングeventは実行しません
1480 ワード
mysqlのタイミングでトリガーされたeventが作成された後、予定されたイベントは発生しませんでしたが、以下のようにまとめられています.
リファレンスページhttps://www.iteye.com/blog/liu346435400-1575299
1. event :
mysql event off
event : show variables like 'event_scheduler';
event : set global event_scheduler=1;
event , ,event 。
?
-------- ,event -----------------
my.ini(windows) or my.cnf(linux)
[mysqld]
event_scheduler=ON
2. event ,
, , event
: DEFINER=`root`@`127.0.0.1`
select * from mysql.user where Host='127.0.0.1'
127.0.0.1 ip
3.event DISABLE;
test_event :
: alter event test_event ON COMPLETION PRESERVE DISABLE;
: alter event test_event ON COMPLETION PRESERVE ENABLE;
event: SHOW EVENTS;
select * from information_schema.EVENTS;
4. err log, event , PROCEDURE , PROCEDURE , error
,
event , , event (select * from information_schema.EVENTS;);
[GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'user'@'10.60.40.%' WITH GRANT OPTION;].
, , , 。 event
リファレンスページhttps://www.iteye.com/blog/liu346435400-1575299