1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
create table t1 (a int) engine=innodb; reset master; set autocommit=0; insert t1 values (1); flush tables with read lock; show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000001 107 commit; show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000001 107 unlock tables; drop table t1; set autocommit=1; |