MySQL 8 Cookbook

Extracting a row event display

In row-based replication, by default, binary format is displayed. To view the ROW information, you have to pass the --verbose or -v option to mysqlbinlog. The binary format of row events are shown as comments in the form of pseudo-SQL statements with lines beginning with ###. You can see that a single UPDATE statement is rewritten as an UPDATE statement for each row:

shell>  mysqlbinlog /data/mysql/binlogs/server1.000001 --start-position=660 --stop-position=1298 --verbose~~# at 660#170815 13:29:02 server id 200  end_log_pos 722 CRC32 0xe0a2ec74     Table_map: `employees`.`salaries` mapped to number 165# at 722#170815 13:29:02 server id 200 end_log_pos 1298 CRC32 0xf0ef8b05 Update_rows: table id 165 flags: STMT_END_F ...