Debian Codegraph @

mysql-test/suite/events/events_slowlog.result

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