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