Server IP : 49.212.180.16 / Your IP : 18.217.140.32 Web Server : Apache System : FreeBSD www2606.sakura.ne.jp 13.0-RELEASE-p14 FreeBSD 13.0-RELEASE-p14 #2: Mon Dec 9 13:54:55 JST 2024 root@www5301.sakura.ne.jp:/usr/obj/usr/src/amd64.amd64/sys/GENERIC amd64 User : utannto ( 1076) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/rs/mysql/5.1/mysql-test/suite/manual/r/ |
Upload File : |
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;