11
11
alter table t1 add c int;
12
12
show binlog events from <binlog_start>;
13
13
Log_name Pos Event_type Server_id End_log_pos Info
14
master-bin.000001 # Query 1 # BEGIN
15
master-bin.000001 # Table_map 1 # table_id: # (mysqltest.t1)
16
master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
17
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
18
master-bin.000001 # Query 1 # COMMIT
14
mysqld-bin.000001 # Query 1 # BEGIN
15
mysqld-bin.000001 # Table_map 1 # table_id: # (mysqltest.t1)
16
mysqld-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
17
mysqld-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
18
mysqld-bin.000001 # Query 1 # COMMIT
21
21
insert into t2 values (1,1);
22
22
show binlog events from <binlog_start>;
23
23
Log_name Pos Event_type Server_id End_log_pos Info
24
master-bin1.000001 # Query 102 # BEGIN
25
master-bin1.000001 # Table_map 102 # table_id: # (mysqltest.t1)
26
master-bin1.000001 # Table_map 102 # table_id: # (mysql.ndb_apply_status)
27
master-bin1.000001 # Write_rows 102 # table_id: # flags: STMT_END_F
28
master-bin1.000001 # Query 102 # COMMIT
29
master-bin1.000001 # Query 102 # BEGIN
30
master-bin1.000001 # Table_map 102 # table_id: # (mysqltest.t2)
31
master-bin1.000001 # Table_map 102 # table_id: # (mysql.ndb_apply_status)
32
master-bin1.000001 # Write_rows 102 # table_id: #
33
master-bin1.000001 # Write_rows 102 # table_id: # flags: STMT_END_F
34
master-bin1.000001 # Query 102 # COMMIT
24
mysqld-bin.000001 # Query 2 # BEGIN
25
mysqld-bin.000001 # Table_map 2 # table_id: # (mysqltest.t1)
26
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
27
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
28
mysqld-bin.000001 # Query 2 # COMMIT
29
mysqld-bin.000001 # Query 2 # BEGIN
30
mysqld-bin.000001 # Table_map 2 # table_id: # (mysqltest.t2)
31
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
32
mysqld-bin.000001 # Write_rows 2 # table_id: #
33
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
34
mysqld-bin.000001 # Query 2 # COMMIT
41
41
insert into t1 values (1,1);
42
42
show binlog events from <binlog_start>;
43
43
Log_name Pos Event_type Server_id End_log_pos Info
44
master-bin.000001 # Query 1 # BEGIN
45
master-bin.000001 # Table_map 1 # table_id: # (mysqltest.t2)
46
master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
47
master-bin.000001 # Write_rows 1 # table_id: #
48
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
49
master-bin.000001 # Query 1 # COMMIT
50
master-bin.000001 # Query 1 # use `mysqltest`; drop table t1
51
master-bin.000001 # Query 1 # use `mysqltest`; drop table t2
52
master-bin.000001 # Query 1 # use `mysqltest`; create table t1 (d int key, e int) engine=ndb
53
master-bin.000001 # Query 1 # use `mysqltest`; create table t2 (d int key, e int) engine=ndb
54
master-bin.000001 # Query 1 # BEGIN
55
master-bin.000001 # Table_map 1 # table_id: # (mysqltest.t1)
56
master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
57
master-bin.000001 # Write_rows 1 # table_id: #
58
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
59
master-bin.000001 # Query 1 # COMMIT
44
mysqld-bin.000001 # Query 1 # BEGIN
45
mysqld-bin.000001 # Table_map 1 # table_id: # (mysqltest.t2)
46
mysqld-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
47
mysqld-bin.000001 # Write_rows 1 # table_id: #
48
mysqld-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
49
mysqld-bin.000001 # Query 1 # COMMIT
50
mysqld-bin.000001 # Query 1 # use `mysqltest`; drop table t1
51
mysqld-bin.000001 # Query 1 # use `mysqltest`; drop table t2
52
mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t1 (d int key, e int) engine=ndb
53
mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t2 (d int key, e int) engine=ndb
54
mysqld-bin.000001 # Query 1 # BEGIN
55
mysqld-bin.000001 # Table_map 1 # table_id: # (mysqltest.t1)
56
mysqld-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
57
mysqld-bin.000001 # Write_rows 1 # table_id: #
58
mysqld-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
59
mysqld-bin.000001 # Query 1 # COMMIT
61
61
insert into t2 values (1,1);
62
62
show binlog events from <binlog_start>;
63
63
Log_name Pos Event_type Server_id End_log_pos Info
64
master-bin1.000001 # Query 1 # use `mysqltest`; drop table `t1`
65
master-bin1.000001 # Query 1 # use `mysqltest`; drop table `t2`
66
master-bin1.000001 # Query 1 # use `mysqltest`; create table t1 (d int key, e int) engine=ndb
67
master-bin1.000001 # Query 1 # use `mysqltest`; create table t2 (d int key, e int) engine=ndb
68
master-bin1.000001 # Query 102 # BEGIN
69
master-bin1.000001 # Table_map 102 # table_id: # (mysqltest.t1)
70
master-bin1.000001 # Table_map 102 # table_id: # (mysql.ndb_apply_status)
71
master-bin1.000001 # Write_rows 102 # table_id: #
72
master-bin1.000001 # Write_rows 102 # table_id: # flags: STMT_END_F
73
master-bin1.000001 # Query 102 # COMMIT
74
master-bin1.000001 # Query 102 # BEGIN
75
master-bin1.000001 # Table_map 102 # table_id: # (mysqltest.t2)
76
master-bin1.000001 # Table_map 102 # table_id: # (mysql.ndb_apply_status)
77
master-bin1.000001 # Write_rows 102 # table_id: #
78
master-bin1.000001 # Write_rows 102 # table_id: # flags: STMT_END_F
79
master-bin1.000001 # Query 102 # COMMIT
64
mysqld-bin.000001 # Query 1 # use `mysqltest`; drop table `t1`
65
mysqld-bin.000001 # Query 1 # use `mysqltest`; drop table `t2`
66
mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t1 (d int key, e int) engine=ndb
67
mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t2 (d int key, e int) engine=ndb
68
mysqld-bin.000001 # Query 2 # BEGIN
69
mysqld-bin.000001 # Table_map 2 # table_id: # (mysqltest.t1)
70
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
71
mysqld-bin.000001 # Write_rows 2 # table_id: #
72
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
73
mysqld-bin.000001 # Query 2 # COMMIT
74
mysqld-bin.000001 # Query 2 # BEGIN
75
mysqld-bin.000001 # Table_map 2 # table_id: # (mysqltest.t2)
76
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
77
mysqld-bin.000001 # Write_rows 2 # table_id: #
78
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
79
mysqld-bin.000001 # Query 2 # COMMIT
80
80
drop database mysqltest;