解析MySQL binlog --（4）TABLE_MAP_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 */ |
+------------------+-----+-------------+-----------+-------------+---------------------------------------------+
9 rows in set (0.00 sec)
页:
[1]