This descriptor event appears at the start of every binary log file, defining the server version, binlog version, and header lengths for all event types.
This is a descriptor event that is written to the beginning of a binary log file, at position 4 (after the 4 magic number bytes). The whole event written to disk is byte<19> event header + data fields.
The Event Type is 15 (0x0f).
The binary log format version. This is 4 .
The MariaDB server version (example: 10.8.1-debug-log), padded with 0x00 bytes on the right.
Timestamp in seconds when this event was created (this is the moment when the binary log was created). This value is redundant; the same value occurs in the timestamp header field.
Checksum Algorithm Type
CRC32 4 bytes (value matters only if checksum algo is CRC32)
timestamp => 4d af 15 5a.
type = 0f => 15.
server_id = 1.
Event Size = fc => 252.
format version = 04 00 => 4.
server's version = 10.2.10-MariaDB-log .... [50 bytes].
create time = 4d af 15 5a.
header_length = 13 => 19.
timestamp => 12 ad 26 5aa.
type = 0f => 15.
server_id = 84 27 00 00 => 00 00 27 84 => 10116.
Event Size = fc => 245.
format version = 04 00 => 4.
server's version = 10.1.16-MariaDB.log .... [50 bytes].
create time = 12 ad 26 5a.
header_length = 13 => 19.
This page is licensed: CC BY-SA / Gnu FDL
-19 gives the size of the extra headers field at the end of the header for other events.byte Variable-sized. An array that indicates the post-header lengths for all event types. There is one byte per event type that the server knows about. The value 'n' comes from the following formula:
Flags = 00 => 0.
checksum_algo = 01 => 1 (CRC32).
CRC32 bytes = d6 ce 13 e2.
Flags = 00 => 0.
checksum_algo = 0 => 0 (NONE).
CRC32 bytes = 2b 91 c2 91 (useless).
n = event_size - header length - offset (2 + 50 + 4 + 1) - checksum_algo - checksum4d af 15 5a 0f 01 00 00 00 fc 00 00 00 00 01 00 M..Z............
00 00 00 04 00 31 30 2e 32 2e 31 30 2d 4d 61 72 .....10.2.10-Mar
69 61 44 42 2d 6c 6f 67 00 00 00 00 00 00 00 00 iaDB-log.......
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00 00 00 00 00 00 00 00 00 00 00 4d af 15 5a 13 ...........M..Z.
00 12 00 04 04 04 04 12 00 00 e4 00 04 1a 08 00 ................
00 00 08 08 08 02 00 00 00 0a 0a 0a 00 00 00 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 04 13 04 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 04 13 04 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 04 13 04 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 04 13 04 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 04 13 04 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 04 13 04 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 04 13 04 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 04 13 04 00 ................
0d 08 08 08 0a 0a 0a 01 d6 ce 13 e2 ............12 ad 26 5a 0f 84 27 00 00 f5 00 00 00 f9 00 00 ..&Z..'.........
00 01 00 04 00 31 30 2e 31 2e 31 36 2d 4d 61 72 .....10.1.16-Mar
69 61 44 42 00 6c 6f 67 00 00 00 00 00 00 00 00 iaDB.log........
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00 00 00 00 00 00 00 12 ad 26 5a 13 38 0d 00 08 .........&Z.8...
00 12 00 04 04 04 04 12 00 00 dd 00 04 1a 08 00 ................
00 00 08 08 08 02 00 00 00 0a 0a 0a 00 00 00 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00 00 00 00 00 00 00 00 00 00 00 00 04 13 04 00 ................
00 2b 91 c2 91