mysqlのタイミングeventは実行しません

1480 ワード

mysqlのタイミングでトリガーされたeventが作成された後、予定されたイベントは発生しませんでしたが、以下のようにまとめられています.
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