1set @event_scheduler_save= @@global.event_scheduler; 2set @slow_query_log_save= @@global.slow_query_log; 3set global event_scheduler= on; 4set global slow_query_log= on; 5set global long_query_time=0.2; 6create table t1 (i int); 7insert into t1 values (0); 8create event ev on schedule at CURRENT_TIMESTAMP + INTERVAL 1 second do update t1 set i=1+sleep(0.5); 9FOUND 1 /update t1 set i=1/ in mysqld-slow.log 10drop table t1; 11set global event_scheduler= @event_scheduler_save; 12set global slow_query_log= @slow_query_log_save; 13set global long_query_time= @@session.long_query_time; 14