解析MySQL binlog --（5）ROWS_EVENT
mysql> show binlog events in "mysql-bin.000002"; +------------------+------+-------------+-----------+-------------+-----------------------------------------------------------------+| Log_name | Pos| Event_type| Server_id | End_log_pos | Info |
+------------------+------+-------------+-----------+-------------+-----------------------------------------------------------------+
| mysql-bin.000002 | 4 | Format_desc | 11 | 120 | Server ver: 5.6.26-debug-log, Binlog ver: 4 |
| mysql-bin.000002 |120 | Query | 11 | 191 | BEGIN |
| mysql-bin.000002 |191 | Table_map | 11 | 236 | table_id: 70 (yzs.t1) |
| mysql-bin.000002 |236 | Write_rows| 11 | 280 | table_id: 70 flags: STMT_END_F |
| mysql-bin.000002 |280 | Xid | 11 | 311 | COMMIT /* xid=9 */ |
| mysql-bin.000002 |311 | Query | 11 | 382 | BEGIN |
| mysql-bin.000002 |382 | Table_map | 11 | 427 | table_id: 70 (yzs.t1) |
| mysql-bin.000002 |427 | Write_rows| 11 | 471 | table_id: 70 flags: STMT_END_F |
| mysql-bin.000002 |471 | Xid | 11 | 502 | COMMIT /* xid=37 */ |
| mysql-bin.000002 |502 | Query | 11 | 573 | BEGIN |
| mysql-bin.000002 |573 | Table_map | 11 | 618 | table_id: 70 (yzs.t1) |
| mysql-bin.000002 |618 | Write_rows| 11 | 662 | table_id: 70 flags: STMT_END_F |
| mysql-bin.000002 |662 | Xid | 11 | 693 | COMMIT /* xid=46 */ |
| mysql-bin.000002 |693 | Query | 11 | 764 | BEGIN |
| mysql-bin.000002 |764 | Table_map | 11 | 809 | table_id: 70 (yzs.t1) |
| mysql-bin.000002 |809 | Write_rows| 11 | 853 | table_id: 70 flags: STMT_END_F |
| mysql-bin.000002 |853 | Xid | 11 | 884 | COMMIT /* xid=47 */ |
| mysql-bin.000002 |884 | Query | 11 | 955 | BEGIN |
| mysql-bin.000002 |955 | Table_map | 11 | 1000 | table_id: 70 (yzs.t1) |
| mysql-bin.000002 | 1000 | Write_rows| 11 | 1044 | table_id: 70 flags: STMT_END_F |
| mysql-bin.000002 | 1044 | Xid | 11 | 1075 | COMMIT /* xid=56 */ |
| mysql-bin.000002 | 1075 | Query | 11 | 1199 | use `yzs`; create table t2(id1 int primary key,id2 int,id3 int) |
| mysql-bin.000002 | 1199 | Query | 11 | 1270 | BEGIN |
| mysql-bin.000002 | 1270 | Table_map | 11 | 1316 | table_id: 71 (yzs.t2) |
| mysql-bin.000002 | 1316 | Write_rows| 11 | 1364 | table_id: 71 flags: STMT_END_F |
| mysql-bin.000002 | 1364 | Xid | 11 | 1395 | COMMIT /* xid=59 */ |
| mysql-bin.000002 | 1395 | Query | 11 | 1466 | BEGIN |
| mysql-bin.000002 | 1466 | Table_map | 11 | 1512 | table_id: 71 (yzs.t2) |
| mysql-bin.000002 | 1512 | Delete_rows | 11 | 1560 | table_id: 71 flags: STMT_END_F |
| mysql-bin.000002 | 1560 | Xid | 11 | 1591 | COMMIT /* xid=60 */ |
| mysql-bin.000002 | 1591 | Query | 11 | 1662 | BEGIN |
| mysql-bin.000002 | 1662 | Table_map | 11 | 1708 | table_id: 71 (yzs.t2) |
| mysql-bin.000002 | 1708 | Write_rows| 11 | 1756 | table_id: 71 flags: STMT_END_F |
| mysql-bin.000002 | 1756 | Xid | 11 | 1787 | COMMIT /* xid=63 */ |
+------------------+------+-------------+-----------+-------------+-----------------------------------------------------------------+
34 rows in set (0.00 sec)
页:
[1]