1085
1085
Log_name Pos Event_type Server_id End_log_pos Info
1086
1086
master-bin.000001 4 Format_desc 1 107 Server version, Binlog ver: 4
1087
1087
master-bin.000001 107 Query 1 228 use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
1088
master-bin.000001 228 Table_map 1 270 table_id: # (test.t1)
1089
master-bin.000001 270 Write_rows 1 316 table_id: # flags: STMT_END_F
1090
master-bin.000001 316 Query 1 392 use `test`; drop table t1
1088
master-bin.000001 228 Query 1 296 use `test`; BEGIN
1089
master-bin.000001 296 Table_map 1 338 table_id: # (test.t1)
1090
master-bin.000001 338 Write_rows 1 384 table_id: # flags: STMT_END_F
1091
master-bin.000001 384 Query 1 453 use `test`; COMMIT
1092
master-bin.000001 453 Query 1 529 use `test`; drop table t1
1091
1093
End of 5.0 tests
1093
1095
create table t1 (id tinyint auto_increment primary key);
1111
1113
show binlog events from <binlog_start>;
1112
1114
Log_name Pos Event_type Server_id End_log_pos Info
1113
1115
master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
1116
master-bin.000001 # Query # # use `test`; BEGIN
1114
1117
master-bin.000001 # Table_map # # table_id: # (test.t1)
1115
1118
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1119
master-bin.000001 # Query # # use `test`; COMMIT
1116
1120
master-bin.000001 # Query # # use `test`; drop table t1
1117
1121
master-bin.000001 # Query # # use `test`; create table t1 (a int)
1118
1122
master-bin.000001 # Query # # use `test`; BEGIN
1123
1127
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
1124
1128
`a` int(11) DEFAULT NULL
1130
master-bin.000001 # Query # # use `mysql`; BEGIN
1126
1131
master-bin.000001 # Table_map # # table_id: # (mysql.user)
1127
1132
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1133
master-bin.000001 # Query # # use `mysql`; COMMIT
1134
master-bin.000001 # Query # # use `mysql`; BEGIN
1128
1135
master-bin.000001 # Table_map # # table_id: # (mysql.user)
1129
1136
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
1137
master-bin.000001 # Query # # use `mysql`; COMMIT
1138
master-bin.000001 # Query # # use `mysql`; BEGIN
1130
1139
master-bin.000001 # Table_map # # table_id: # (mysql.user)
1131
1140
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1141
master-bin.000001 # Query # # use `mysql`; COMMIT
1132
1142
drop table t1,t2,t3,tt1;
1133
1143
create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
1134
1144
set @@session.auto_increment_increment=1, @@session.auto_increment_offset=1;
1138
1148
show binlog events from <binlog_start>;
1139
1149
Log_name Pos Event_type Server_id End_log_pos Info
1140
1150
master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
1151
master-bin.000001 # Query # # use `test`; BEGIN
1141
1152
master-bin.000001 # Table_map # # table_id: # (test.t1)
1142
1153
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1154
master-bin.000001 # Query # # use `test`; COMMIT
1143
1155
master-bin.000001 # Query # # use `test`; drop table t1
1144
1156
master-bin.000001 # Query # # use `test`; create table t1 (a int)
1145
1157
master-bin.000001 # Query # # use `test`; BEGIN
1150
1162
master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
1151
1163
`a` int(11) DEFAULT NULL
1165
master-bin.000001 # Query # # use `mysql`; BEGIN
1153
1166
master-bin.000001 # Table_map # # table_id: # (mysql.user)
1154
1167
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1168
master-bin.000001 # Query # # use `mysql`; COMMIT
1169
master-bin.000001 # Query # # use `mysql`; BEGIN
1155
1170
master-bin.000001 # Table_map # # table_id: # (mysql.user)
1156
1171
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
1172
master-bin.000001 # Query # # use `mysql`; COMMIT
1173
master-bin.000001 # Query # # use `mysql`; BEGIN
1157
1174
master-bin.000001 # Table_map # # table_id: # (mysql.user)
1158
1175
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1176
master-bin.000001 # Query # # use `mysql`; COMMIT
1159
1177
master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2`,`t3` /* generated by server */
1160
1178
master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
1161
master-bin.000001 # Table_map # # table_id: # (test.t1)
1162
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1163
master-bin.000001 # Table_map # # table_id: # (test.t1)
1164
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1165
master-bin.000001 # Table_map # # table_id: # (test.t1)
1166
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1179
master-bin.000001 # Query # # use `test`; BEGIN
1180
master-bin.000001 # Table_map # # table_id: # (test.t1)
1181
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1182
master-bin.000001 # Query # # use `test`; COMMIT
1183
master-bin.000001 # Query # # use `test`; BEGIN
1184
master-bin.000001 # Table_map # # table_id: # (test.t1)
1185
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1186
master-bin.000001 # Query # # use `test`; COMMIT
1187
master-bin.000001 # Query # # use `test`; BEGIN
1188
master-bin.000001 # Table_map # # table_id: # (test.t1)
1189
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1190
master-bin.000001 # Query # # use `test`; COMMIT
1167
1191
insert delayed into t1 values (null),(null),(null),(null);
1168
1192
insert delayed into t1 values (null),(null),(400),(null);