Back to Display Filter Reference
| Field name | Type | Description | Versions |
|---|---|---|---|
| mysql.affected_rows | Unsigned integer, 8 bytes | Affected Rows | 1.0.0 to 1.6.5 |
| mysql.binlog.file_name | Character string | Binlog file name | 1.6.0 to 1.6.5 |
| mysql.binlog.flags | Unsigned integer, 2 bytes | Binlog Flags | 1.6.0 to 1.6.5 |
| mysql.binlog.position | Unsigned integer, 4 bytes | Binlog Position | 1.6.0 to 1.6.5 |
| mysql.binlog.server_id | Unsigned integer, 2 bytes | Binlog server id | 1.6.0 to 1.6.5 |
| mysql.caps | Unsigned integer, 2 bytes | Caps | 1.0.0 to 1.4.11 |
| mysql.caps.cd | Boolean | Connect With Database | 1.0.0 to 1.6.5 |
| mysql.caps.client | Unsigned integer, 2 bytes | Client Capabilities | 1.6.0 to 1.6.5 |
| mysql.caps.cp | Boolean | Can use compression protocol | 1.0.0 to 1.6.5 |
| mysql.caps.cu | Boolean | Speaks 4.1 protocol (new flag) | 1.0.0 to 1.6.5 |
| mysql.caps.fr | Boolean | Found Rows | 1.0.0 to 1.6.5 |
| mysql.caps.ia | Boolean | Interactive Client | 1.0.0 to 1.6.5 |
| mysql.caps.ii | Boolean | Ignore sigpipes | 1.0.0 to 1.6.5 |
| mysql.caps.is | Boolean | Ignore Spaces before '(' | 1.0.0 to 1.6.5 |
| mysql.caps.lf | Boolean | Long Column Flags | 1.0.0 to 1.6.5 |
| mysql.caps.li | Boolean | Can Use LOAD DATA LOCAL | 1.0.0 to 1.6.5 |
| mysql.caps.lp | Boolean | Long Password | 1.0.0 to 1.6.5 |
| mysql.caps.mr | Boolean | Supports multiple results | 1.0.0 to 1.6.5 |
| mysql.caps.ms | Boolean | Supports multiple statements | 1.0.0 to 1.6.5 |
| mysql.caps.ns | Boolean | Don't Allow database.table.column | 1.0.0 to 1.6.5 |
| mysql.caps.ob | Boolean | ODBC Client | 1.0.0 to 1.6.5 |
| mysql.caps.rs | Boolean | Speaks 4.1 protocol (old flag) | 1.0.0 to 1.6.5 |
| mysql.caps.sc | Boolean | Can do 4.1 authentication | 1.0.0 to 1.6.5 |
| mysql.caps.server | Unsigned integer, 2 bytes | Server Capabilities | 1.6.0 to 1.6.5 |
| mysql.caps.sl | Boolean | Switch to SSL after handshake | 1.0.0 to 1.6.5 |
| mysql.caps.ta | Boolean | Knows about transactions | 1.0.0 to 1.6.5 |
| mysql.charset | Unsigned integer, 1 byte | Charset | 1.0.0 to 1.6.5 |
| mysql.command | Unsigned integer, 1 byte | Command | 1.6.0 to 1.6.5 |
| mysql.eof | Unsigned integer, 1 byte | EOF marker | 1.0.0 to 1.6.5 |
| mysql.error.message | Character string | Error message | 1.0.0 to 1.6.5 |
| mysql.error_code | Unsigned integer, 2 bytes | Error Code | 1.0.0 to 1.6.5 |
| mysql.exec_flags | Unsigned integer, 1 byte | Flags (unused) | 1.0.0 to 1.6.5 |
| mysql.exec_iter | Unsigned integer, 4 bytes | Iterations (unused) | 1.0.0 to 1.6.5 |
| mysql.extcaps | Unsigned integer, 2 bytes | Ext. Caps | 1.0.0 to 1.4.11 |
| mysql.extcaps.client | Unsigned integer, 2 bytes | Extended Client Capabilities | 1.6.0 to 1.6.5 |
| mysql.extra | Unsigned integer, 8 bytes | Extra data | 1.0.0 to 1.6.5 |
| mysql.field.catalog | Character string | Catalog | 1.2.0 to 1.6.5 |
| mysql.field.charsetnr | Unsigned integer, 2 bytes | Charset number | 1.2.0 to 1.6.5 |
| mysql.field.db | Character string | Database | 1.2.0 to 1.6.5 |
| mysql.field.decimals | Unsigned integer, 1 byte | Decimals | 1.2.0 to 1.6.5 |
| mysql.field.default | Character string | Default | 1.4.1 to 1.6.5 |
| mysql.field.flags | Unsigned integer, 2 bytes | Flags | 1.2.0 to 1.6.5 |
| mysql.field.flags.auto_increment | Boolean | Auto increment | 1.2.0 to 1.6.5 |
| mysql.field.flags.binary | Boolean | Binary | 1.2.0 to 1.6.5 |
| mysql.field.flags.blob | Boolean | Blob | 1.2.0 to 1.6.5 |
| mysql.field.flags.enum | Boolean | Enum | 1.2.0 to 1.6.5 |
| mysql.field.flags.multiple_key | Boolean | Multiple key | 1.2.0 to 1.6.5 |
| mysql.field.flags.not_null | Boolean | Not null | 1.2.0 to 1.6.5 |
| mysql.field.flags.primary_key | Boolean | Primary key | 1.2.0 to 1.6.5 |
| mysql.field.flags.set | Boolean | Set | 1.2.0 to 1.6.5 |
| mysql.field.flags.timestamp | Boolean | Timestamp | 1.2.0 to 1.6.5 |
| mysql.field.flags.unique_key | Boolean | Unique key | 1.2.0 to 1.6.5 |
| mysql.field.flags.unsigned | Boolean | Unsigned | 1.2.0 to 1.6.5 |
| mysql.field.flags.zero_fill | Boolean | Zero fill | 1.2.0 to 1.6.5 |
| mysql.field.length | Unsigned integer, 4 bytes | Length | 1.2.0 to 1.6.5 |
| mysql.field.name | Character string | Name | 1.2.0 to 1.6.5 |
| mysql.field.org_name | Character string | Original name | 1.2.0 to 1.6.5 |
| mysql.field.org_table | Character string | Original table | 1.2.0 to 1.6.5 |
| mysql.field.table | Character string | Table | 1.2.0 to 1.6.5 |
| mysql.field.type | Unsigned integer, 1 byte | Type | 1.2.0 to 1.6.5 |
| mysql.insert_id | Unsigned integer, 8 bytes | Last INSERT ID | 1.0.0 to 1.6.5 |
| mysql.login_request | Label | Login Request | 1.6.0 to 1.6.5 |
| mysql.max_packet | Unsigned integer, 3 bytes | MAX Packet | 1.0.0 to 1.6.5 |
| mysql.message | Character string | Message | 1.0.0 to 1.6.5 |
| mysql.num_fields | Unsigned integer, 8 bytes | Number of fields | 1.0.0 to 1.6.5 |
| mysql.num_rows | Unsigned integer, 4 bytes | Rows to fetch | 1.0.0 to 1.6.5 |
| mysql.opcode | Unsigned integer, 1 byte | Command | 1.0.0 to 1.4.11 |
| mysql.option | Unsigned integer, 2 bytes | Option | 1.0.0 to 1.6.5 |
| mysql.packet_length | Unsigned integer, 3 bytes | Packet Length | 1.0.0 to 1.6.5 |
| mysql.packet_number | Unsigned integer, 1 byte | Packet Number | 1.0.0 to 1.6.5 |
| mysql.param | Unsigned integer, 2 bytes | Parameter | 1.0.0 to 1.6.5 |
| mysql.parameter | Character string | Parameter | 1.0.0 to 1.4.11 |
| mysql.passwd | Sequence of bytes | Password | 1.0.0 to 1.6.5 |
| mysql.payload | Sequence of bytes | Payload | 1.0.0 to 1.6.5 |
| mysql.protocol | Unsigned integer, 1 byte | Protocol | 1.0.0 to 1.6.5 |
| mysql.query | Character string | Statement | 1.0.0 to 1.6.5 |
| mysql.refresh | Unsigned integer, 1 byte | Refresh Option | 1.0.0 to 1.6.5 |
| mysql.request | Label | Request Command | 1.6.0 to 1.6.5 |
| mysql.response_code | Unsigned integer, 1 byte | Response Code | 1.0.0 to 1.4.11 |
| mysql.rfsh.grants | Boolean | reload permissions | 1.0.0 to 1.6.5 |
| mysql.rfsh.hosts | Boolean | flush hosts | 1.0.0 to 1.6.5 |
| mysql.rfsh.log | Boolean | flush logfiles | 1.0.0 to 1.6.5 |
| mysql.rfsh.master | Boolean | flush master status | 1.0.0 to 1.6.5 |
| mysql.rfsh.slave | Boolean | flush slave status | 1.0.0 to 1.6.5 |
| mysql.rfsh.status | Boolean | reset statistics | 1.0.0 to 1.6.5 |
| mysql.rfsh.tables | Boolean | flush tables | 1.0.0 to 1.6.5 |
| mysql.rfsh.threads | Boolean | empty thread cache | 1.0.0 to 1.6.5 |
| mysql.row.length | Unsigned integer, 1 byte | length | 1.2.0 to 1.4.11 |
| mysql.row.text | Character string | text | 1.2.0 to 1.6.5 |
| mysql.salt | Character string | Salt | 1.0.0 to 1.6.5 |
| mysql.salt2 | Character string | Salt | 1.0.0 to 1.6.5 |
| mysql.schema | Character string | Schema | 1.0.0 to 1.6.5 |
| mysql.server_greeting | Label | Server Greeting | 1.6.0 to 1.6.5 |
| mysql.server_language | Unsigned integer, 1 byte | Server Language | 1.6.0 to 1.6.5 |
| mysql.server_status | Unsigned integer, 2 bytes | Server Status | 1.6.0 to 1.6.5 |
| mysql.shutdown | Unsigned integer, 1 byte | Shutdown Level | 1.6.0 to 1.6.5 |
| mysql.sqlstate | Character string | SQL state | 1.0.0 to 1.6.5 |
| mysql.stat.ac | Boolean | AUTO_COMMIT | 1.0.0 to 1.6.5 |
| mysql.stat.bi | Boolean | Bad index used | 1.0.0 to 1.6.5 |
| mysql.stat.bs | Boolean | No backslash escapes | 1.0.0 to 1.6.5 |
| mysql.stat.cr | Boolean | Cursor exists | 1.0.0 to 1.6.5 |
| mysql.stat.dr | Boolean | database dropped | 1.0.0 to 1.6.5 |
| mysql.stat.it | Boolean | In transaction | 1.0.0 to 1.6.5 |
| mysql.stat.lr | Boolean | Last row sebd | 1.0.0 to 1.6.5 |
| mysql.stat.mr | Boolean | More results | 1.0.0 to 1.6.5 |
| mysql.stat.mu | Boolean | Multi query - more resultsets | 1.0.0 to 1.6.5 |
| mysql.stat.ni | Boolean | No index used | 1.0.0 to 1.6.5 |
| mysql.status | Unsigned integer, 2 bytes | Status | 1.0.0 to 1.4.11 |
| mysql.stmt_id | Unsigned integer, 4 bytes | Statement ID | 1.0.0 to 1.6.5 |
| mysql.table_name | Character string | Table Name | 1.6.0 to 1.6.5 |
| mysql.thd_id | Unsigned integer, 4 bytes | Thread ID | 1.0.0 to 1.6.5 |
| mysql.thread_id | Unsigned integer, 4 bytes | Thread ID | 1.0.0 to 1.6.5 |
| mysql.unused | Character string | Unused | 1.0.0 to 1.6.5 |
| mysql.user | Character string | Username | 1.0.0 to 1.6.5 |
| mysql.version | Character string | Version | 1.0.0 to 1.6.5 |
| mysql.warnings | Unsigned integer, 2 bytes | Warnings | 1.0.0 to 1.6.5 |