diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb_defrag_binlog.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb_defrag_binlog.result | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_defrag_binlog.result b/mysql-test/suite/innodb/r/innodb_defrag_binlog.result new file mode 100644 index 00000000..b97061cc --- /dev/null +++ b/mysql-test/suite/innodb/r/innodb_defrag_binlog.result @@ -0,0 +1,31 @@ +include/master-slave.inc +[connection master] +drop table if exists t1; +create table t1(a int not null primary key auto_increment, b varchar(256), key second(b)) engine=innodb; +insert into t1 values (1, REPEAT("a", 256)); +insert into t1 values (2, REPEAT("a", 256)); +optimize table t1; +Table Op Msg_type Msg_text +test.t1 optimize status OK +drop table t1; +include/show_binlog_events.inc +Log_name Pos Event_type Server_id End_log_pos Info +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; create table t1(a int not null primary key auto_increment, b varchar(256), key second(b)) engine=innodb +master-bin.000001 # Gtid # # BEGIN GTID #-#-# +master-bin.000001 # Annotate_rows # # insert into t1 values (1, REPEAT("a", 256)) +master-bin.000001 # Table_map # # table_id: # (test.t1) +master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F +master-bin.000001 # Xid # # COMMIT /* XID */ +master-bin.000001 # Gtid # # BEGIN GTID #-#-# +master-bin.000001 # Annotate_rows # # insert into t1 values (2, REPEAT("a", 256)) +master-bin.000001 # Table_map # # table_id: # (test.t1) +master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F +master-bin.000001 # Xid # # COMMIT /* XID */ +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; optimize table t1 +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ +include/rpl_end.inc |