blob: 599efeb3e2d7600edcebe3cdf87b60228561bb3a (
plain)
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 98
commit;
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB
master-bin.000001 98
unlock tables;
drop table t1;
set autocommit=1;
|
