O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required