|
上面 binlog.000001 文件是我们正在操作的binlog。
- MySQL> show binlog events in 'binlog.000001';
- +---------------+------+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
- +---------------+------+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | binlog.000001 | 4 | Format_desc | 1 | 124 | Server ver: 8.0.11, Binlog ver: 4 |
- | binlog.000001 | 124 | Previous_gtids | 1 | 155 | |
- | binlog.000001 | 155 | Anonymous_Gtid | 1 | 228 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
- | binlog.000001 | 228 | Query | 1 | 368 | use `Apache Flinkdb`; DROP TABLE `tab` /* generated by server */ /* xid=22 */ |
- | binlog.000001 | 368 | Anonymous_Gtid | 1 | 443 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
- | binlog.000001 | 443 | Query | 1 | 670 | use `Apache Flinkdb`; create table tab(
- id INT NOT NULL AUTO_INCREMENT,
- user VARCHAR(100) NOT NULL,
- clicks INT NOT NULL,
- PRIMARY KEY (id)
- ) /* xid=23 */ |
- | binlog.000001 | 670 | Anonymous_Gtid | 1 | 745 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
- | binlog.000001 | 745 | Query | 1 | 823 | BEGIN |
- | binlog.000001 | 823 | Table_map | 1 | 890 | table_id: 96 (Apache Flinkdb.tab) |
- | binlog.000001 | 890 | Write_rows | 1 | 940 | table_id: 96 flags: STMT_END_F |
- | binlog.000001 | 940 | Xid | 1 | 971 | COMMIT /* xid=25 */ |
- | binlog.000001 | 971 | Anonymous_Gtid | 1 | 1046 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
- | binlog.000001 | 1046 | Query | 1 | 1124 | BEGIN |
- | binlog.000001 | 1124 | Table_map | 1 | 1191 | table_id: 96 (Apache Flinkdb.tab) |
- | binlog.000001 | 1191 | Write_rows | 1 | 1240 | table_id: 96 flags: STMT_END_F |
- | binlog.000001 | 1240 | Xid | 1 | 1271 | COMMIT /* xid=26 */ |
- | binlog.000001 | 1271 | Anonymous_Gtid | 1 | 1346 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
- | binlog.000001 | 1346 | Query | 1 | 1433 | BEGIN |
- | binlog.000001 | 1433 | Table_map | 1 | 1500 | table_id: 96 (Apache Flinkdb.tab) |
- | binlog.000001 | 1500 | Update_rows | 1 | 1566 | table_id: 96 flags: STMT_END_F |
- | binlog.000001 | 1566 | Xid | 1 | 1597 | COMMIT /* xid=27 */ |
- | binlog.000001 | 1597 | Anonymous_Gtid | 1 | 1672 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
- | binlog.000001 | 1672 | Query | 1 | 1750 | BEGIN |
- | binlog.000001 | 1750 | Table_map | 1 | 1817 | table_id: 96 (Apache Flinkdb.tab) |
- | binlog.000001 | 1817 | Write_rows | 1 | 1866 | table_id: 96 flags: STMT_END_F |
- | binlog.000001 | 1866 | Xid | 1 | 1897 | COMMIT /* xid=28 */ |
- | binlog.000001 | 1897 | Anonymous_Gtid | 1 | 1972 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
- | binlog.000001 | 1972 | Query | 1 | 2059 | BEGIN |
- | binlog.000001 | 2059 | Table_map | 1 | 2126 | table_id: 96 (Apache Flinkdb.tab) |
- | binlog.000001 | 2126 | Update_rows | 1 | 2190 | table_id: 96 flags: STMT_END_F |
- | binlog.000001 | 2190 | Xid | 1 | 2221 | COMMIT /* xid=29 */ |
- | binlog.000001 | 2221 | Anonymous_Gtid | 1 | 2296 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
- | binlog.000001 | 2296 | Query | 1 | 2383 | BEGIN |
- | binlog.000001 | 2383 | Table_map | 1 | 2450 | table_id: 96 (Apache Flinkdb.tab) |
- | binlog.000001 | 2450 | Update_rows | 1 | 2516 | table_id: 96 flags: STMT_END_F |
- | binlog.000001 | 2516 | Xid | 1 | 2547 | COMMIT /* xid=30 */ |
- +---------------+------+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- 36 rows in set (0.00 sec)
（编辑：晋中站长网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
