QUERY_EVENT

• Event Type = 0x02.

Fixed data part:

• uint<4> The ID of the thread that issued this statement on the master.

• uint<4> The time in seconds that the statement took to execute.

• uint<1> The length of the name of the database which was the default database when the statement was executed. This name appears later, in the variable data part. It is necessary for statements such as INSERT INTO t VALUES(1) that don't specify the database and rely on the default database previously selected by USE.

• The error code resulting from execution of the statement on the master.

• The length of the status variable block.

Variable data part:

• byte<n> Zero or more status variables. Each status variable consists of one byte code identifying the variable stored, followed by the value of the variable. The format of the value is variable-specific. The number of bytes 'n' is the length of the status variable block (read in fixed data part).

• string<NUL> The default database name (null-terminated).

• string<EOF> The SQL statement. By subtraction the size of the statement can be known.

• uint<4> bitmask.

• uint<8> 8-byte bitmask.

• uint<1> length

• string<length +1> catalog name + '\0'

• uint<2> auto_increment increment

• uint<2> auto_increment offset

• uint<2> client character set

• uint<2> collation_connection

• uint<2> collation_server

• uint<1> length

• string<length> time zone

• uint<1> length

• string<length> catalog

• uint<2> code The mapping between code and names are defined in sql_locale.cc.

• uint<2> database collation

• uint<8> table bittmask Every bit of this variable represents a table, and is set to 1 if the corresponding table is to be updated by this statement.

• Not in use any more

• uint<4> original event length

• uint<1> user name length

• string<length> user name

• uint<1> host name length

• string<length> host name

• MySQL only

• uint<1> count

• for (i=0;i < count; i++)

  • Null terminated database name

• MySQL only

• uint<3> microsecond part

• MariaDB only

• uint<3> microsecond part

• MariaDB only

• uint<8> xid

• Event Time[4] = 71 17 28 5a ===> 1512576881.

• Event Type[1] = 2.

• Server_id[4] = 8c 27 00 00 ===> 10124.

• Event Size = 55 00 00 00 ===> 85.

• Next Pos = 01 09 00 00 ===> 2305.

• Flags = 00 00 => 0.

• Thread ID[4] = 66 01 00 00 ===> 358.

• Execution Time[4] = 00 00 00 00 => 0 seconds.

• Statement default database name len[1] = 00 => 0 (no default database).

• Error code[2] = 00 00 => 0 (no errors).

• Status variable block len[2] = 1a 00 => 26.

• Status variables[n] = 00 ... 08 00.

• The default database[string] = 00 = 0 (no default database).

• The SQL statement[string] = TRUNCATE TABLE test.t4.

• 4a 69 9e ed.

• Thread ID[4] = 66 01 00 00 ===> 358.

• Execution Time[4] = 10 00 00 00 => 1 second.

• Statement default database name len[1] = 04 => 4 (default database is "test").

• Error code[2] = 00 00 => 0 (no errors).

• Status variable block len[2] = 1a 00 => 26.

• Status variables[n] = 00 ... 08 00.

• The default database[string] = 74 65 73 74 00 ⇒ test.

• The SQL statement[string] = TRUNCATE TABLE test.t4.

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

Header

Fields

Status Variables

Q_FLAGS2_CODE (0x00)

Q_SQL_MODE_CODE (0x01)

Q_CATALOG_NZ_CODE (0x02)

Q_AUTO_INCREMENT (0x03)

Q_CHARSET_CODE (0x04)

Q_TIMEZONE_CODE (0x05)

Q_CATALOG_NZ_CODE (0x06)

Q_LC_TIME_NAMES_CODE (0x07)

Q_CHARSET_DATABASE_CODE (0x08)

Q_TABLE_MAP_FOR_UPDATE_CODE (0x09)

Q_MASTER_DATA_WRITTEN_CODE (0x0A)

Q_INVOKER (0x0B|)

Q_UPDATED_DB_NAMES (0x0C)

Q_MICROSECONDS (0x0D)

Q_HRNOW (0x80)

Q_XID (0x81)

Example With CRC32

Header, 19 Bytes

Content, Variable Data

CRC32, 4 Bytes

Example With Default Database and CRC32

Content, Variable Data