stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; # Second_behind reports 0 Seconds_Behind_Master 0 drop table if exists t1; Warnings: Note 1051 Unknown table 't1' create table t1 (f1 int); flush logs /* contaminate rli->last_master_timestamp */; lock table t1 write; insert into t1 values (1); # bug emulated: reports slave threads starting time about 3*3 not 3 secs Seconds_Behind_Master 9 unlock tables; flush logs /* this time rli->last_master_timestamp is not affected */; lock table t1 write; insert into t1 values (2); # reports the correct diff with master query time about 3+3 secs Seconds_Behind_Master 7 unlock tables; drop table t1;