mysql binlog查看常用命令

1、查看当前正在写入的binlog文件

show master status\G;

*************************** 1. row ***************************
             File: mysql-bin.000002
         Position: 155
     Binlog_Do_DB: 
 Binlog_Ignore_DB: 
Executed_Gtid_Set: 
1 row in set (0.01 sec)

2、只查看第一个binlog文件的内容

show binlog events;
+------------------+-----+----------------+-----------+-------------+--------------------------------------+
| Log_name         | Pos | Event_type     | Server_id | End_log_pos | Info                                 |
+------------------+-----+----------------+-----------+-------------+--------------------------------------+
| mysql-bin.000001 |   4 | Format_desc    |         1 |         124 | Server ver: 8.0.13, Binlog ver: 4    |
| mysql-bin.000001 | 124 | Previous_gtids |         1 |         155 |                                      |
| mysql-bin.000001 | 155 | Anonymous_Gtid |         1 |