All pages
Powered by GitBook
1 of 1

Loading...

INTVAR_EVENT

This event records integer values for auto-increment columns or the LAST_INSERT_ID function, ensuring that these values are replicated deterministically.

An INTVAR_EVENT is written every time a statement uses an auto increment column or the LAST_INSERT_ID() function.

Header

  • Event Type is 5 (0x05).

Fields

  • Type.

  • Value.

Type

Example From mysqlbinlog Utility, CRC32

Example Event As It's Written In The Binlog File

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

0x00

Invalid value.

0x01

LAST_INSERT_ID.

0x02

Insert id (auto_increment).

uint<1>
uint<8>
# at 738
#180610 11:20:56 server id 1  end_log_pos 770 CRC32 0xf5a23f2d 	Intvar
SET LAST_INSERT_ID=1/*!*/;
78 ed 1c 5b 05 01 00 00 00 20 00       x..[..... .
00 00 02 03 00 00 00 00 01 01 00 00 00 00 00 00  ................
00 2d 3f a2 f5                                   .-?..