1CREATE TABLE t1 (id INT) ENGINE = InnoDB; 2SET BINLOG_FORMAT = STATEMENT; 3RESET MASTER; 4SET AUTOCOMMIT = 0; 5INSERT INTO t1 VALUES (1); 6include/show_binlog_events.inc 7Log_name Pos Event_type Server_id End_log_pos Info 8SET AUTOCOMMIT = 1; 9include/show_binlog_events.inc 10Log_name Pos Event_type Server_id End_log_pos Info 11master-bin.000001 # Query # # BEGIN 12master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 13master-bin.000001 # Xid # # COMMIT /* XID */ 14COMMIT; 15RESET MASTER; 16SET AUTOCOMMIT = 0; 17BEGIN; 18INSERT INTO t1 VALUES (2); 19include/show_binlog_events.inc 20Log_name Pos Event_type Server_id End_log_pos Info 21SET AUTOCOMMIT = 1; 22include/show_binlog_events.inc 23Log_name Pos Event_type Server_id End_log_pos Info 24master-bin.000001 # Query # # BEGIN 25master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 26master-bin.000001 # Xid # # COMMIT /* XID */ 27INSERT INTO t1 VALUES (3); 28include/show_binlog_events.inc 29Log_name Pos Event_type Server_id End_log_pos Info 30master-bin.000001 # Query # # BEGIN 31master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 32master-bin.000001 # Xid # # COMMIT /* XID */ 33master-bin.000001 # Query # # BEGIN 34master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 35master-bin.000001 # Xid # # COMMIT /* XID */ 36COMMIT; 37include/show_binlog_events.inc 38Log_name Pos Event_type Server_id End_log_pos Info 39master-bin.000001 # Query # # BEGIN 40master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 41master-bin.000001 # Xid # # COMMIT /* XID */ 42master-bin.000001 # Query # # BEGIN 43master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 44master-bin.000001 # Xid # # COMMIT /* XID */ 45COMMIT; 46RESET MASTER; 47SET AUTOCOMMIT = 1; 48INSERT INTO t1 VALUES (1); 49include/show_binlog_events.inc 50Log_name Pos Event_type Server_id End_log_pos Info 51master-bin.000001 # Query # # BEGIN 52master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 53master-bin.000001 # Xid # # COMMIT /* XID */ 54SET AUTOCOMMIT = 1; 55include/show_binlog_events.inc 56Log_name Pos Event_type Server_id End_log_pos Info 57master-bin.000001 # Query # # BEGIN 58master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 59master-bin.000001 # Xid # # COMMIT /* XID */ 60COMMIT; 61RESET MASTER; 62SET AUTOCOMMIT = 1; 63BEGIN; 64INSERT INTO t1 VALUES (2); 65include/show_binlog_events.inc 66Log_name Pos Event_type Server_id End_log_pos Info 67SET AUTOCOMMIT = 1; 68include/show_binlog_events.inc 69Log_name Pos Event_type Server_id End_log_pos Info 70INSERT INTO t1 VALUES (3); 71include/show_binlog_events.inc 72Log_name Pos Event_type Server_id End_log_pos Info 73COMMIT; 74include/show_binlog_events.inc 75Log_name Pos Event_type Server_id End_log_pos Info 76master-bin.000001 # Query # # BEGIN 77master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 78master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 79master-bin.000001 # Xid # # COMMIT /* XID */ 80COMMIT; 81RESET MASTER; 82SET AUTOCOMMIT = 0; 83INSERT INTO t1 VALUES (1); 84include/show_binlog_events.inc 85Log_name Pos Event_type Server_id End_log_pos Info 86SET AUTOCOMMIT = 0; 87include/show_binlog_events.inc 88Log_name Pos Event_type Server_id End_log_pos Info 89COMMIT; 90RESET MASTER; 91SET AUTOCOMMIT = 0; 92BEGIN; 93INSERT INTO t1 VALUES (2); 94include/show_binlog_events.inc 95Log_name Pos Event_type Server_id End_log_pos Info 96SET AUTOCOMMIT = 0; 97include/show_binlog_events.inc 98Log_name Pos Event_type Server_id End_log_pos Info 99INSERT INTO t1 VALUES (3); 100include/show_binlog_events.inc 101Log_name Pos Event_type Server_id End_log_pos Info 102COMMIT; 103include/show_binlog_events.inc 104Log_name Pos Event_type Server_id End_log_pos Info 105master-bin.000001 # Query # # BEGIN 106master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 107master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 108master-bin.000001 # Xid # # COMMIT /* XID */ 109COMMIT; 110RESET MASTER; 111SET AUTOCOMMIT = 1; 112INSERT INTO t1 VALUES (1); 113include/show_binlog_events.inc 114Log_name Pos Event_type Server_id End_log_pos Info 115master-bin.000001 # Query # # BEGIN 116master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 117master-bin.000001 # Xid # # COMMIT /* XID */ 118SET AUTOCOMMIT = 0; 119include/show_binlog_events.inc 120Log_name Pos Event_type Server_id End_log_pos Info 121master-bin.000001 # Query # # BEGIN 122master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 123master-bin.000001 # Xid # # COMMIT /* XID */ 124COMMIT; 125RESET MASTER; 126SET AUTOCOMMIT = 1; 127BEGIN; 128INSERT INTO t1 VALUES (2); 129include/show_binlog_events.inc 130Log_name Pos Event_type Server_id End_log_pos Info 131SET AUTOCOMMIT = 0; 132include/show_binlog_events.inc 133Log_name Pos Event_type Server_id End_log_pos Info 134INSERT INTO t1 VALUES (3); 135include/show_binlog_events.inc 136Log_name Pos Event_type Server_id End_log_pos Info 137COMMIT; 138include/show_binlog_events.inc 139Log_name Pos Event_type Server_id End_log_pos Info 140master-bin.000001 # Query # # BEGIN 141master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 142master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 143master-bin.000001 # Xid # # COMMIT /* XID */ 144COMMIT; 145SET BINLOG_FORMAT = ROW; 146RESET MASTER; 147SET AUTOCOMMIT = 0; 148INSERT INTO t1 VALUES (1); 149include/show_binlog_events.inc 150Log_name Pos Event_type Server_id End_log_pos Info 151SET AUTOCOMMIT = 1; 152include/show_binlog_events.inc 153Log_name Pos Event_type Server_id End_log_pos Info 154master-bin.000001 # Query # # BEGIN 155master-bin.000001 # Table_map # # table_id: # (test.t1) 156master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 157master-bin.000001 # Xid # # COMMIT /* XID */ 158COMMIT; 159RESET MASTER; 160SET AUTOCOMMIT = 0; 161BEGIN; 162INSERT INTO t1 VALUES (2); 163include/show_binlog_events.inc 164Log_name Pos Event_type Server_id End_log_pos Info 165SET AUTOCOMMIT = 1; 166include/show_binlog_events.inc 167Log_name Pos Event_type Server_id End_log_pos Info 168master-bin.000001 # Query # # BEGIN 169master-bin.000001 # Table_map # # table_id: # (test.t1) 170master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 171master-bin.000001 # Xid # # COMMIT /* XID */ 172INSERT INTO t1 VALUES (3); 173include/show_binlog_events.inc 174Log_name Pos Event_type Server_id End_log_pos Info 175master-bin.000001 # Query # # BEGIN 176master-bin.000001 # Table_map # # table_id: # (test.t1) 177master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 178master-bin.000001 # Xid # # COMMIT /* XID */ 179master-bin.000001 # Query # # BEGIN 180master-bin.000001 # Table_map # # table_id: # (test.t1) 181master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 182master-bin.000001 # Xid # # COMMIT /* XID */ 183COMMIT; 184include/show_binlog_events.inc 185Log_name Pos Event_type Server_id End_log_pos Info 186master-bin.000001 # Query # # BEGIN 187master-bin.000001 # Table_map # # table_id: # (test.t1) 188master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 189master-bin.000001 # Xid # # COMMIT /* XID */ 190master-bin.000001 # Query # # BEGIN 191master-bin.000001 # Table_map # # table_id: # (test.t1) 192master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 193master-bin.000001 # Xid # # COMMIT /* XID */ 194COMMIT; 195RESET MASTER; 196SET AUTOCOMMIT = 1; 197INSERT INTO t1 VALUES (1); 198include/show_binlog_events.inc 199Log_name Pos Event_type Server_id End_log_pos Info 200master-bin.000001 # Query # # BEGIN 201master-bin.000001 # Table_map # # table_id: # (test.t1) 202master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 203master-bin.000001 # Xid # # COMMIT /* XID */ 204SET AUTOCOMMIT = 1; 205include/show_binlog_events.inc 206Log_name Pos Event_type Server_id End_log_pos Info 207master-bin.000001 # Query # # BEGIN 208master-bin.000001 # Table_map # # table_id: # (test.t1) 209master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 210master-bin.000001 # Xid # # COMMIT /* XID */ 211COMMIT; 212RESET MASTER; 213SET AUTOCOMMIT = 1; 214BEGIN; 215INSERT INTO t1 VALUES (2); 216include/show_binlog_events.inc 217Log_name Pos Event_type Server_id End_log_pos Info 218SET AUTOCOMMIT = 1; 219include/show_binlog_events.inc 220Log_name Pos Event_type Server_id End_log_pos Info 221INSERT INTO t1 VALUES (3); 222include/show_binlog_events.inc 223Log_name Pos Event_type Server_id End_log_pos Info 224COMMIT; 225include/show_binlog_events.inc 226Log_name Pos Event_type Server_id End_log_pos Info 227master-bin.000001 # Query # # BEGIN 228master-bin.000001 # Table_map # # table_id: # (test.t1) 229master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 230master-bin.000001 # Table_map # # table_id: # (test.t1) 231master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 232master-bin.000001 # Xid # # COMMIT /* XID */ 233COMMIT; 234RESET MASTER; 235SET AUTOCOMMIT = 0; 236INSERT INTO t1 VALUES (1); 237include/show_binlog_events.inc 238Log_name Pos Event_type Server_id End_log_pos Info 239SET AUTOCOMMIT = 0; 240include/show_binlog_events.inc 241Log_name Pos Event_type Server_id End_log_pos Info 242COMMIT; 243RESET MASTER; 244SET AUTOCOMMIT = 0; 245BEGIN; 246INSERT INTO t1 VALUES (2); 247include/show_binlog_events.inc 248Log_name Pos Event_type Server_id End_log_pos Info 249SET AUTOCOMMIT = 0; 250include/show_binlog_events.inc 251Log_name Pos Event_type Server_id End_log_pos Info 252INSERT INTO t1 VALUES (3); 253include/show_binlog_events.inc 254Log_name Pos Event_type Server_id End_log_pos Info 255COMMIT; 256include/show_binlog_events.inc 257Log_name Pos Event_type Server_id End_log_pos Info 258master-bin.000001 # Query # # BEGIN 259master-bin.000001 # Table_map # # table_id: # (test.t1) 260master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 261master-bin.000001 # Table_map # # table_id: # (test.t1) 262master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 263master-bin.000001 # Xid # # COMMIT /* XID */ 264COMMIT; 265RESET MASTER; 266SET AUTOCOMMIT = 1; 267INSERT INTO t1 VALUES (1); 268include/show_binlog_events.inc 269Log_name Pos Event_type Server_id End_log_pos Info 270master-bin.000001 # Query # # BEGIN 271master-bin.000001 # Table_map # # table_id: # (test.t1) 272master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 273master-bin.000001 # Xid # # COMMIT /* XID */ 274SET AUTOCOMMIT = 0; 275include/show_binlog_events.inc 276Log_name Pos Event_type Server_id End_log_pos Info 277master-bin.000001 # Query # # BEGIN 278master-bin.000001 # Table_map # # table_id: # (test.t1) 279master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 280master-bin.000001 # Xid # # COMMIT /* XID */ 281COMMIT; 282RESET MASTER; 283SET AUTOCOMMIT = 1; 284BEGIN; 285INSERT INTO t1 VALUES (2); 286include/show_binlog_events.inc 287Log_name Pos Event_type Server_id End_log_pos Info 288SET AUTOCOMMIT = 0; 289include/show_binlog_events.inc 290Log_name Pos Event_type Server_id End_log_pos Info 291INSERT INTO t1 VALUES (3); 292include/show_binlog_events.inc 293Log_name Pos Event_type Server_id End_log_pos Info 294COMMIT; 295include/show_binlog_events.inc 296Log_name Pos Event_type Server_id End_log_pos Info 297master-bin.000001 # Query # # BEGIN 298master-bin.000001 # Table_map # # table_id: # (test.t1) 299master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 300master-bin.000001 # Table_map # # table_id: # (test.t1) 301master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 302master-bin.000001 # Xid # # COMMIT /* XID */ 303COMMIT; 304RESET MASTER; 305SET AUTOCOMMIT = 0; 306INSERT INTO t1 VALUES (1); 307include/show_binlog_events.inc 308Log_name Pos Event_type Server_id End_log_pos Info 309LOCK TABLES t1 WRITE; 310include/show_binlog_events.inc 311Log_name Pos Event_type Server_id End_log_pos Info 312master-bin.000001 # Query # # BEGIN 313master-bin.000001 # Table_map # # table_id: # (test.t1) 314master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 315master-bin.000001 # Xid # # COMMIT /* XID */ 316INSERT INTO t1 VALUES (2); 317include/show_binlog_events.inc 318Log_name Pos Event_type Server_id End_log_pos Info 319master-bin.000001 # Query # # BEGIN 320master-bin.000001 # Table_map # # table_id: # (test.t1) 321master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 322master-bin.000001 # Xid # # COMMIT /* XID */ 323UNLOCK TABLES; 324include/show_binlog_events.inc 325Log_name Pos Event_type Server_id End_log_pos Info 326master-bin.000001 # Query # # BEGIN 327master-bin.000001 # Table_map # # table_id: # (test.t1) 328master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 329master-bin.000001 # Xid # # COMMIT /* XID */ 330master-bin.000001 # Query # # BEGIN 331master-bin.000001 # Table_map # # table_id: # (test.t1) 332master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 333master-bin.000001 # Xid # # COMMIT /* XID */ 334COMMIT; 335include/show_binlog_events.inc 336Log_name Pos Event_type Server_id End_log_pos Info 337master-bin.000001 # Query # # BEGIN 338master-bin.000001 # Table_map # # table_id: # (test.t1) 339master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 340master-bin.000001 # Xid # # COMMIT /* XID */ 341master-bin.000001 # Query # # BEGIN 342master-bin.000001 # Table_map # # table_id: # (test.t1) 343master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F 344master-bin.000001 # Xid # # COMMIT /* XID */ 345DROP TABLE t1; 346