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