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.
Event Type is 160 (0xa0)
string The SQL statement (not null-terminated)
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