ANNOTATE_ROWS_EVENT

ANNOTATE_ROWS_EVENT events accompany row events and describe the query which caused the row event.

You can enable this with --binlog-annotate-row-events (default on from MariaDB 10.2.4).

In the binary log, each Annotate_rows event precedes the corresponding Table map event.

For additional information refer to the annotate_rows_log_event documentation.

Note: the master server sends ANNOTATE_ROWS_EVENT events only if the Slave server connects with the BINLOG_SEND_ANNOTATE_ROWS_EVENT flag (value is 2) in the COM_BINLOG_DUMP Slave Registration phase.

Header

• Event Type is 160 (0xa0)

Fields

• string The SQL statement (not null-terminated)

Complete Example with CRC32

ee b7 15 5a a0 01 00 00  00 36 00 00 00 80 0b 00  ...Z.....6......
00 00 00 69 6e 73 65 72  74 20 69 6e 74 6f 20 74  ...insert into t
65 73 74 2e 74 34 20 76  61 6c 75 65 73 28 31 30  est.t4 values(10
30 29 6d 4c 42 33                                 0)mLB3

_{This page is licensed: CC BY-SA / Gnu FDL}