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.

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

Comments

Comments loading...