Display Filter Reference: MySQL Protocol

Protocol field name: mysql

Versions: 1.0.0 to 3.0.0

Back to Display Filter Reference

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

Riverbed is Wireshark's primary sponsor and provides our funding. They also make great products that fully integrate with Wireshark.

I have a lot of traffic...

ANSWER: SteelCentral™ Packet Analyzer PE
  • • Visually rich, powerful LAN analyzer
  • • Quickly access very large pcap files
  • • Professional, customizable reports
  • • Advanced triggers and alerts
Learn More

Buy Now

No, really, I have a LOT of traffic…

ANSWER: SteelCentral™ AppResponse 11
  • • Full stack analysis – from packets to pages
  • • Rich performance metrics & pre-defined insights for fast problem identification/resolution
  • • Modular, flexible solution for deeply-analyzing network & application performance
Learn More