Display Filter Reference: MySQL Protocol

Protocol field name: mysql

Versions: 1.0.0 to 4.0.3

Back to Display Filter Reference

Field name Description Type Versions
mariadb.bulk.flag.autoid Return Generated Autoincrement IDs Boolean 3.4.0 to 4.0.3
mariadb.bulk.flag.sendtypes Send Parameter Types Boolean 3.4.0 to 4.0.3
mariadb.bulk.flags MariaDB Bulk Capabilities Unsigned integer (2 bytes) 3.4.0 to 4.0.3
mariadb.bulk.indicators Indicator Unsigned integer (1 byte) 3.4.0 to 4.0.3
mariadb.bulk.paramtypesg Bulk Parameter Types Label 3.4.0 to 4.0.3
mariadb.bulk.row_nr Row nr Unsigned integer (4 bytes) 4.0.0 to 4.0.3
mariadb.caps.bo Bulk Operations Boolean 3.4.0 to 4.0.3
mariadb.caps.cm Multi commands Boolean 3.4.0 to 4.0.3
mariadb.caps.em Extended metadata Boolean 3.4.0 to 4.0.3
mariadb.caps.me Cache metadata Boolean 4.0.0 to 4.0.3
mariadb.caps.pr Progress indication Boolean 3.4.0 to 4.0.3
mariadb.charset Charset Unsigned integer (1 byte) 3.4.0 to 4.0.3
mariadb.extcaps.client MariaDB Extended Client Capabilities Unsigned integer (4 bytes) 3.4.0 to 4.0.3
mariadb.extcaps.server MariaDB Extended Server Capabilities Unsigned integer (4 bytes) 3.4.0 to 4.0.3
mariadb.length Length Unsigned integer (8 bytes) 3.6.0 to 4.0.3
mariadb.prefix Prefix Unsigned integer (1 byte) 3.6.0 to 4.0.3
mariadb.server_language Server Language Unsigned integer (1 byte) 3.4.0 to 4.0.3
mysql.affected_rows Affected Rows Unsigned integer (8 bytes) 1.0.0 to 4.0.3
mysql.auth_plugin Authentication Plugin Character string 2.0.0 to 4.0.3
mysql.auth_plugin.length Authentication Plugin Length Unsigned integer (1 byte) 2.0.0 to 4.0.3
mysql.auth_switch_request.data Auth Method Data Byte sequence 2.0.0 to 4.0.3
mysql.auth_switch_request.name Auth Method Name Character string 2.0.0 to 4.0.3
mysql.auth_switch_request.status Status Unsigned integer (1 byte) 2.0.0 to 4.0.3
mysql.auth_switch_response.data Auth Method Data Byte sequence 2.0.0 to 4.0.3
mysql.binlog.event_checksum Checksum Unsigned integer (4 bytes) 4.0.0 to 4.0.3
mysql.binlog.event_header.event_size Event Size Unsigned integer (4 bytes) 4.0.0 to 4.0.3
mysql.binlog.event_header.event_type Binlog Event Type Unsigned integer (1 byte) 4.0.0 to 4.0.3
mysql.binlog.event_header.flags Binlog Event Flags Unsigned integer (2 bytes) 4.0.0 to 4.0.3
mysql.binlog.event_header.log_position Binlog Position Unsigned integer (4 bytes) 4.0.0 to 4.0.3
mysql.binlog.event_header.server_id Server ID Unsigned integer (4 bytes) 4.0.0 to 4.0.3
mysql.binlog.event_header.timestamp Timestamp Date and time 4.0.0 to 4.0.3
mysql.binlog.event_heartbeat_v2 Binlog Event: HEARTBEAT_LOG_EVENT_V2 Label 4.0.0 to 4.0.3
mysql.binlog.event_heartbeat_v2_otw Entry Label 4.0.0 to 4.0.3
mysql.binlog.event_heartbeat_v2_otw_type Type Unsigned integer (1 byte) 4.0.0 to 4.0.3
mysql.binlog.file_name Binlog file name Character string 1.6.0 to 4.0.3
mysql.binlog.flags Binlog Flags Unsigned integer (2 bytes) 1.6.0 to 4.0.3
mysql.binlog.hb_event.filename Binlog Filename Character string 4.0.0 to 4.0.3
mysql.binlog.hb_event.log_position Binlog Position Unsigned integer (8 bytes) 4.0.0 to 4.0.3
mysql.binlog.master_id Master id Unsigned integer (4 bytes) 4.0.0 to 4.0.3
mysql.binlog.position Binlog Position Unsigned integer (4 bytes) 1.6.0 to 4.0.3
mysql.binlog.replication_rank Replication rank Unsigned integer (4 bytes) 4.0.0 to 4.0.3
mysql.binlog.server_id Binlog server id Unsigned integer (4 bytes) 1.6.0 to 4.0.3
mysql.binlog.slave_hostname Slave hostname Character string 4.0.0 to 4.0.3
mysql.binlog.slave_hostname_length Slave hostname length Unsigned integer (1 byte) 4.0.0 to 4.0.3
mysql.binlog.slave_mysql_port Slave MySQL port Unsigned integer (2 bytes) 4.0.0 to 4.0.3
mysql.binlog.slave_password Slave password Character string 4.0.0 to 4.0.3
mysql.binlog.slave_password_length Slave password length Unsigned integer (1 byte) 4.0.0 to 4.0.3
mysql.binlog.slave_user Slave user Character string 4.0.0 to 4.0.3
mysql.binlog.slave_user_length Slave user length Unsigned integer (1 byte) 4.0.0 to 4.0.3
mysql.caps Caps Unsigned integer (2 bytes) 1.0.0 to 1.4.15
mysql.caps.ca Connect attrs Boolean 1.12.0 to 4.0.3
mysql.caps.cap_ext Capability Extension Boolean 4.0.0 to 4.0.3
mysql.caps.cd Connect With Database Boolean 1.0.0 to 4.0.3
mysql.caps.client Client Capabilities Unsigned integer (2 bytes) 1.6.0 to 4.0.3
mysql.caps.compress_zsd ZSTD Compression Algorithm Boolean 4.0.0 to 4.0.3
mysql.caps.cp Can use compression protocol Boolean 1.0.0 to 4.0.3
mysql.caps.cu Speaks 4.1 protocol (new flag) Boolean 1.0.0 to 4.0.3
mysql.caps.deprecate_eof Deprecate EOF Boolean 2.2.0 to 4.0.3
mysql.caps.ep Client can handle expired passwords Boolean 2.0.0 to 4.0.3
mysql.caps.fr Found Rows Boolean 1.0.0 to 4.0.3
mysql.caps.ia Interactive Client Boolean 1.0.0 to 4.0.3
mysql.caps.ii Ignore sigpipes Boolean 1.0.0 to 4.0.3
mysql.caps.is Ignore Spaces before '(' Boolean 1.0.0 to 4.0.3
mysql.caps.lf Long Column Flags Boolean 1.0.0 to 4.0.3
mysql.caps.li Can Use LOAD DATA LOCAL Boolean 1.0.0 to 4.0.3
mysql.caps.lp Long Password Boolean 1.0.0 to 4.0.3
mysql.caps.mf_auth Multifactor Authentication Boolean 4.0.0 to 4.0.3
mysql.caps.mr Multiple results Boolean 1.0.0 to 4.0.3
mysql.caps.ms Multiple statements Boolean 1.0.0 to 4.0.3
mysql.caps.ns Don't Allow database.table.column Boolean 1.0.0 to 4.0.3
mysql.caps.ob ODBC Client Boolean 1.0.0 to 4.0.3
mysql.caps.optional_metadata Client can hanle optional resultset metadata Boolean 4.0.0 to 4.0.3
mysql.caps.pa Plugin Auth Boolean 1.12.0 to 4.0.3
mysql.caps.pm PS Multiple results Boolean 1.12.0 to 4.0.3
mysql.caps.query_attrs Query Attributes Boolean 4.0.0 to 4.0.3
mysql.caps.rs Speaks 4.1 protocol (old flag) Boolean 1.0.0 to 4.0.3
mysql.caps.sc Can do 4.1 authentication Boolean 1.0.0 to 4.0.3
mysql.caps.server Server Capabilities Unsigned integer (2 bytes) 1.6.0 to 4.0.3
mysql.caps.session_track Session variable tracking Boolean 1.12.0 to 4.0.3
mysql.caps.sl Switch to SSL after handshake Boolean 1.0.0 to 4.0.3
mysql.caps.ta Knows about transactions Boolean 1.0.0 to 4.0.3
mysql.caps.unused Unused Unsigned integer (2 bytes) 1.12.0 to 4.0.3
mysql.charset Charset Unsigned integer (1 byte) 1.0.0 to 4.0.3
mysql.client_auth_plugin Client Auth Plugin Character string 2.0.0 to 4.0.3
mysql.command Command Unsigned integer (1 byte) 1.6.0 to 4.0.3
mysql.command.invalid Unknown/invalid command code Label 1.12.0 to 4.0.3
mysql.compressed_packet_length Compressed Packet Length Unsigned integer (3 bytes) 2.2.0 to 4.0.3
mysql.compressed_packet_length_uncompressed Uncompressed Packet Length Unsigned integer (3 bytes) 2.2.0 to 4.0.3
mysql.compressed_packet_number Compressed Packet Number Unsigned integer (3 bytes) 2.2.0 to 4.0.3
mysql.compression.zstd_level ZSTD Compression Level Unsigned integer (1 byte) 4.0.0 to 4.0.3
mysql.connattrs Connection Attributes Label 2.0.0 to 4.0.3
mysql.connattrs.attr Connection Attribute Label 2.0.0 to 4.0.3
mysql.connattrs.length Connection Attributes length Unsigned integer (8 bytes) 2.0.0 to 4.0.3
mysql.connattrs.name Connection Attribute Name Character string 2.0.0 to 4.0.3
mysql.connattrs.name.length Connection Attribute Name Length Unsigned integer (8 bytes) 2.0.0 to 4.0.3
mysql.connattrs.value Connection Attribute Value Character string 2.0.0 to 4.0.3
mysql.connattrs.value.length Connection Attribute Value Length Unsigned integer (8 bytes) 4.0.0 to 4.0.3
mysql.dissector_incomplete FIXME - dissector is incomplete Label 1.12.0 to 4.0.3
mysql.eof EOF marker Unsigned integer (1 byte) 1.0.0 to 4.0.3
mysql.eof.wrong_state EOF Marker found while connection in wrong state. Label 1.12.0 to 3.6.11
mysql.error.message Error message Character string 1.0.0 to 4.0.3
mysql.error_code Error Code Unsigned integer (2 bytes) 1.0.0 to 4.0.3
mysql.exec.field.datetime.length Length Signed integer (1 byte) 1.8.0 to 4.0.3
mysql.exec.field.day Day Signed integer (1 byte) 1.8.0 to 4.0.3
mysql.exec.field.double Value (Double) Floating point (double-precision) 1.8.0 to 4.0.3
mysql.exec.field.float Value (Float) Floating point (single-precision) 1.8.0 to 4.0.3
mysql.exec.field.hour Hour Signed integer (1 byte) 1.8.0 to 4.0.3
mysql.exec.field.long Value (INT32) Signed integer (4 bytes) 1.8.0 to 4.0.3
mysql.exec.field.longlong Value (INT64) Signed integer (8 bytes) 1.8.0 to 4.0.3
mysql.exec.field.minute Minute Signed integer (1 byte) 1.8.0 to 4.0.3
mysql.exec.field.month Month Signed integer (1 byte) 1.8.0 to 4.0.3
mysql.exec.field.null Value: -NULL- Label 4.0.0 to 4.0.3
mysql.exec.field.second Second Signed integer (1 byte) 1.8.0 to 4.0.3
mysql.exec.field.secondb Billionth of a second Signed integer (4 bytes) 1.8.0 to 4.0.3
mysql.exec.field.short Value (INT16) Signed integer (2 bytes) 1.8.0 to 4.0.3
mysql.exec.field.string Value (String) Character string 1.8.0 to 4.0.3
mysql.exec.field.time.days Days Signed integer (4 bytes) 1.8.0 to 4.0.3
mysql.exec.field.time.length Length Signed integer (1 byte) 1.8.0 to 4.0.3
mysql.exec.field.time.sign Flags Unsigned integer (1 byte) 1.8.0 to 4.0.3
mysql.exec.field.tiny Value (INT8) Signed integer (1 byte) 1.8.0 to 4.0.3
mysql.exec.field.unsigned_long Value (UINT32) Unsigned integer (4 bytes) 4.0.0 to 4.0.3
mysql.exec.field.unsigned_longlong Value (UINT64) Unsigned integer (8 bytes) 4.0.0 to 4.0.3
mysql.exec.field.unsigned_short Value (UINT16) Unsigned integer (2 bytes) 4.0.0 to 4.0.3
mysql.exec.field.unsigned_tiny Value (UINT8) Unsigned integer (1 byte) 4.0.0 to 4.0.3
mysql.exec.field.year Year Signed integer (2 bytes) 1.8.0 to 4.0.3
mysql.exec.unsigned Unsigned Unsigned integer (1 byte) 1.8.0 to 4.0.3
mysql.exec_flags Flags (unused) Unsigned integer (1 byte) 1.0.0 to 4.0.3
mysql.exec_iter Iterations (unused) Unsigned integer (4 bytes) 1.0.0 to 4.0.3
mysql.exec_param Parameter Label 1.8.0 to 4.0.3
mysql.extcaps Ext. Caps Unsigned integer (2 bytes) 1.0.0 to 1.4.15
mysql.extcaps.client Extended Client Capabilities Unsigned integer (2 bytes) 1.6.0 to 4.0.3
mysql.extcaps.server Extended Server Capabilities Unsigned integer (2 bytes) 2.0.0 to 4.0.3
mysql.extmeta Extended metadata Label 4.0.0 to 4.0.3
mysql.extmeta.format Extended metadata format Character string 4.0.0 to 4.0.3
mysql.extmeta.key Extended metadata key Unsigned integer (8 bytes) 4.0.0 to 4.0.3
mysql.extmeta.length Extended metadata length Unsigned integer (8 bytes) 4.0.0 to 4.0.3
mysql.extmeta.type Extended metadata type Character string 4.0.0 to 4.0.3
mysql.extmeta_data Extended metadata data Label 4.0.0 to 4.0.3
mysql.extra Extra data Unsigned integer (8 bytes) 1.0.0 to 4.0.3
mysql.field.catalog Catalog Character string 1.2.0 to 4.0.3
mysql.field.charsetnr Charset number Unsigned integer (2 bytes) 1.2.0 to 4.0.3
mysql.field.db Database Character string 1.2.0 to 4.0.3
mysql.field.decimals Decimals Unsigned integer (1 byte) 1.2.0 to 4.0.3
mysql.field.default Default Character string 1.4.1 to 4.0.3
mysql.field.flags Flags Unsigned integer (2 bytes) 1.2.0 to 4.0.3
mysql.field.flags.auto_increment Auto increment Boolean 1.2.0 to 4.0.3
mysql.field.flags.binary Binary Boolean 1.2.0 to 3.6.11
mysql.field.flags.blob Blob Boolean 1.2.0 to 4.0.3
mysql.field.flags.enum Enum Boolean 1.2.0 to 4.0.3
mysql.field.flags.multiple_key Multiple key Boolean 1.2.0 to 4.0.3
mysql.field.flags.not_null Not null Boolean 1.2.0 to 4.0.3
mysql.field.flags.primary_key Primary key Boolean 1.2.0 to 4.0.3
mysql.field.flags.set Set Boolean 1.2.0 to 4.0.3
mysql.field.flags.timestamp Timestamp Boolean 1.2.0 to 4.0.3
mysql.field.flags.unique_key Unique key Boolean 1.2.0 to 4.0.3
mysql.field.flags.unsigned Unsigned Boolean 1.2.0 to 4.0.3
mysql.field.flags.zero_fill Zero fill Boolean 1.2.0 to 4.0.3
mysql.field.length Length Unsigned integer (4 bytes) 1.2.0 to 4.0.3
mysql.field.name Name Character string 1.2.0 to 4.0.3
mysql.field.org_name Original name Character string 1.2.0 to 4.0.3
mysql.field.org_table Original table Character string 1.2.0 to 4.0.3
mysql.field.table Table Character string 1.2.0 to 4.0.3
mysql.field.type Type Unsigned integer (1 byte) 1.2.0 to 4.0.3
mysql.insert_id Last INSERT ID Unsigned integer (8 bytes) 1.0.0 to 4.0.3
mysql.invalid_length Invalid length Label 4.0.0 to 4.0.3
mysql.login_request Login Request Label 1.6.0 to 4.0.3
mysql.max_packet MAX Packet Unsigned integer (4 bytes) 1.0.0 to 4.0.3
mysql.message Message Character string 1.0.0 to 4.0.3
mysql.metadata_follows send metadata Unsigned integer (1 byte) 4.0.0 to 4.0.3
mysql.new_parameter_bound_flag New parameter bound flag Unsigned integer (1 byte) 1.8.0 to 4.0.3
mysql.num_fields Number of fields Unsigned integer (8 bytes) 1.0.0 to 4.0.3
mysql.num_params Number of parameter Unsigned integer (2 bytes) 1.8.0 to 4.0.3
mysql.num_rows Rows to fetch Unsigned integer (4 bytes) 1.0.0 to 4.0.3
mysql.opcode Command Unsigned integer (1 byte) 1.0.0 to 1.4.15
mysql.option Option Unsigned integer (2 bytes) 1.0.0 to 4.0.3
mysql.packet_length Packet Length Unsigned integer (3 bytes) 1.0.0 to 4.0.3
mysql.packet_number Packet Number Unsigned integer (1 byte) 1.0.0 to 4.0.3
mysql.param Parameter Unsigned integer (2 bytes) 1.0.0 to 4.0.3
mysql.parameter Parameter Character string 1.0.0 to 1.4.15
mysql.passwd Password Byte sequence 1.0.0 to 4.0.3
mysql.payload Payload Byte sequence 1.0.0 to 4.0.3
mysql.prepare_response_needed PREPARE Response packet is needed to dissect the payload Label 1.12.0 to 4.0.3
mysql.protocol Protocol Unsigned integer (1 byte) 1.0.0 to 4.0.3
mysql.query Statement Character string 1.0.0 to 4.0.3
mysql.query_attr_name Attribute Name Character string 4.0.0 to 4.0.3
mysql.query_attr_name_type Attribute Name Type Unsigned integer (2 bytes) 4.0.0 to 4.0.3
mysql.query_attr_value Attribute Value Character string 4.0.0 to 4.0.3
mysql.query_attrs Query Attributes Label 4.0.0 to 4.0.3
mysql.query_attrs_count Count Unsigned integer (1 byte) 4.0.0 to 4.0.3
mysql.query_attrs_send_types_to_server Send types to server Boolean 4.0.0 to 4.0.3
mysql.refresh Refresh Option Unsigned integer (1 byte) 1.0.0 to 4.0.3
mysql.request Request Command Label 1.6.0 to 4.0.3
mysql.response_code Response Code Unsigned integer (1 byte) 1.0.0 to 1.4.15, 3.0.0 to 4.0.3
mysql.rfsh.grants reload permissions Boolean 1.0.0 to 4.0.3
mysql.rfsh.hosts flush hosts Boolean 1.0.0 to 4.0.3
mysql.rfsh.log flush logfiles Boolean 1.0.0 to 4.0.3
mysql.rfsh.master flush master status Boolean 1.0.0 to 4.0.3
mysql.rfsh.slave flush slave status Boolean 1.0.0 to 4.0.3
mysql.rfsh.status reset statistics Boolean 1.0.0 to 4.0.3
mysql.rfsh.tables flush tables Boolean 1.0.0 to 4.0.3
mysql.rfsh.threads empty thread cache Boolean 1.0.0 to 4.0.3
mysql.row.length length Unsigned integer (1 byte) 1.2.0 to 1.4.15
mysql.row.nullbuffer Row null buffer Byte sequence 4.0.0 to 4.0.3
mysql.row.text text Character string 1.2.0 to 4.0.3
mysql.salt Salt Character string 1.0.0 to 4.0.3
mysql.salt2 Salt Character string 1.0.0 to 4.0.3
mysql.schema Schema Character string 1.0.0 to 4.0.3
mysql.server_greeting Server Greeting Label 1.6.0 to 4.0.3
mysql.server_language Server Language Unsigned integer (1 byte) 1.6.0 to 4.0.3
mysql.server_status Server Status Unsigned integer (2 bytes) 1.6.0 to 4.0.3
mysql.session_track Session Track Label 1.12.0 to 4.0.3
mysql.session_track.data Session tracking data Label 1.12.0 to 4.0.3
mysql.session_track.data.length Session tracking data length Unsigned integer (8 bytes) 1.12.0 to 4.0.3
mysql.session_track.gtids GTIDs Character string 3.6.0 to 4.0.3
mysql.session_track.gtids.encoding GTIDs encoding Unsigned integer (1 byte) 3.6.0 to 4.0.3
mysql.session_track.gtids.length GTIDs length Unsigned integer (8 bytes) 3.6.0 to 4.0.3
mysql.session_track.length Session tracking length Unsigned integer (8 bytes) 1.12.0 to 4.0.3
mysql.session_track.schema Schema change Character string 1.12.0 to 4.0.3
mysql.session_track.schema.length Schema change length Unsigned integer (8 bytes) 1.12.0 to 4.0.3
mysql.session_track.state_change State change Character string 1.12.0 to 4.0.3
mysql.session_track.sysvar.length System variable change Length Unsigned integer (8 bytes) 1.12.0 to 4.0.3
mysql.session_track.sysvar.name System variable change Name Character string 1.12.0 to 4.0.3
mysql.session_track.sysvar.value System variable change Value Character string 1.12.0 to 4.0.3
mysql.session_track.transaction_characteristics Transaction characteristics Character string 3.6.0 to 4.0.3
mysql.session_track.transaction_characteristics.length Transaction characteristics length Unsigned integer (8 bytes) 3.6.0 to 4.0.3
mysql.session_track.transaction_state Transaction state Character string 3.6.0 to 4.0.3
mysql.session_track.transaction_state.length Transaction state length Unsigned integer (8 bytes) 3.6.0 to 4.0.3
mysql.session_track.type Session tracking type Unsigned integer (1 byte) 1.12.0 to 4.0.3
mysql.shutdown Shutdown Level Unsigned integer (1 byte) 1.6.0 to 4.0.3
mysql.sqlstate SQL state Character string 1.0.0 to 4.0.3
mysql.stat.ac AUTO_COMMIT Boolean 1.0.0 to 4.0.3
mysql.stat.bi Bad index used Boolean 1.0.0 to 4.0.3
mysql.stat.bs No backslash escapes Boolean 1.0.0 to 4.0.3
mysql.stat.cr Cursor exists Boolean 1.0.0 to 4.0.3
mysql.stat.dr Database dropped Boolean 1.0.0 to 4.0.3
mysql.stat.it In transaction Boolean 1.0.0 to 4.0.3
mysql.stat.lr Last row sent Boolean 1.0.0 to 4.0.3
mysql.stat.mc Metadata changed Boolean 3.0.0 to 4.0.3
mysql.stat.mr More results Boolean 1.0.0 to 4.0.3
mysql.stat.mu Multi query / Unused Boolean 1.0.0 to 4.0.3
mysql.stat.ni No index used Boolean 1.0.0 to 4.0.3
mysql.stat.ps_out_params PS Out Params Boolean 1.12.0 to 4.0.3
mysql.stat.query_was_slow Query was slow Boolean 1.12.0 to 4.0.3
mysql.stat.session_state_changed Session state changed Boolean 1.12.0 to 4.0.3
mysql.stat.trans_readonly In Trans Readonly Boolean 3.0.0 to 4.0.3
mysql.status Status Unsigned integer (2 bytes) 1.0.0 to 1.4.15
mysql.stmt_id Statement ID Unsigned integer (4 bytes) 1.0.0 to 4.0.3
mysql.streamed_param This parameter was streamed, its value can be found in Send BLOB packets Label 1.12.0 to 4.0.3
mysql.table_name Table Name Character string 1.6.0 to 4.0.3
mysql.thd_id Thread ID Unsigned integer (4 bytes) 1.0.0 to 3.6.11
mysql.thread_id Thread ID Unsigned integer (4 bytes) 1.0.0 to 4.0.3
mysql.uncompress_failure Uncompression faled Label 4.0.0 to 4.0.3
mysql.unknown_response unknown/invalid response Label 1.12.0 to 4.0.3
mysql.unused Unused Byte sequence 1.0.0 to 4.0.3
mysql.user Username Character string 1.0.0 to 4.0.3
mysql.version Version Character string 1.0.0 to 4.0.3
mysql.warnings Warnings Unsigned integer (2 bytes) 1.0.0 to 4.0.3