2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
show slave status /* Second_behind reports 0 */;;
13
Master_Log_File master-bin.000001
14
Read_Master_Log_Pos 106
17
Relay_Master_Log_File master-bin.000001
23
Replicate_Ignore_Table
24
Replicate_Wild_Do_Table
25
Replicate_Wild_Ignore_Table
29
Exec_Master_Log_Pos 106
40
Seconds_Behind_Master 0
41
Master_SSL_Verify_Server_Cert No
46
drop table if exists t1;
48
Note 1051 Unknown table 't1'
49
create table t1 (f1 int);
50
flush logs /* contaminate rli->last_master_timestamp */;
52
insert into t1 values (1);
53
show slave status /* bug emulated: reports slave threads starting time about 3*3 not 3 secs */;;
59
Master_Log_File master-bin.000001
60
Read_Master_Log_Pos 367
63
Relay_Master_Log_File master-bin.000001
69
Replicate_Ignore_Table
70
Replicate_Wild_Do_Table
71
Replicate_Wild_Ignore_Table
75
Exec_Master_Log_Pos 279
86
Seconds_Behind_Master 9
87
Master_SSL_Verify_Server_Cert No
93
flush logs /* this time rli->last_master_timestamp is not affected */;
95
insert into t1 values (2);
96
show slave status /* reports the correct diff with master query time about 3+3 secs */;;
102
Master_Log_File master-bin.000001
103
Read_Master_Log_Pos 455
106
Relay_Master_Log_File master-bin.000001
108
Slave_SQL_Running Yes
112
Replicate_Ignore_Table
113
Replicate_Wild_Do_Table
114
Replicate_Wild_Ignore_Table
118
Exec_Master_Log_Pos 367
123
Master_SSL_Allowed No
129
Seconds_Behind_Master 7
130
Master_SSL_Verify_Server_Cert No