BINLOG_CHECKPOINT_EVENT

Binlog Checkpoint Event, Event Type is 161 (0xa1) This event specifies a binlog file such that XA crash recovery can start from that file.

Note: there can be more than one in a binlog file.

  • Event type is 161 (0xa1)

Fields

Example Without CRC32

12 ad 26 5a a1 84 27 00  00 27 00 00 00 47 01 00  ..&Z..'..'...G..
00 00 00 10 00 00 00 6d  79 73 71 6c 2d 62 69 6e  .......mysql-bin
2e 30 30 30 30 36 32                              .000062

Header, 19 Bytes

  • Event Timestamp = 12 ad 26 5a

  • Event Type = a1 => 161

  • Server_id = 84 27 00 00 => 00 00 27 84 = 10116

  • Event Size = 27 00 00 00 => 00 00 00 27 = 39

  • Next Pos = 47 01 00 00 => 00 00 01 47 = 327

  • Flags = 00 => 0

Content, Variable Size

  • filename length = 10 00 00 00 = >00 00 00 10 => 16

  • filename = mysql-bin.000062

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

Last updated

Was this helpful?