Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| thd_id | BIGINT UNSIGNED | 20 | null |
|
|
|||
| conn_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||
| user | VARCHAR | 288 | √ | null |
|
|
||
| db | VARCHAR | 64 | √ | null |
|
|
||
| command | VARCHAR | 16 | √ | null |
|
|
||
| state | VARCHAR | 64 | √ | null |
|
|
||
| time | BIGINT | 19 | √ | null |
|
|
||
| current_statement | LONGTEXT | 2147483647 | √ | null |
|
|
||
| statement_latency | VARCHAR | 11 | √ | null |
|
|
||
| progress | DECIMAL | 26,2 | √ | null |
|
|
||
| lock_latency | VARCHAR | 11 | √ | null |
|
|
||
| cpu_latency | VARCHAR | 11 | √ | null |
|
|
||
| rows_examined | BIGINT UNSIGNED | 20 | √ | null |
|
|
||
| rows_sent | BIGINT UNSIGNED | 20 | √ | null |
|
|
||
| rows_affected | BIGINT UNSIGNED | 20 | √ | null |
|
|
||
| tmp_tables | BIGINT UNSIGNED | 20 | √ | null |
|
|
||
| tmp_disk_tables | BIGINT UNSIGNED | 20 | √ | null |
|
|
||
| full_scan | VARCHAR | 3 |
|
|
||||
| last_statement | LONGTEXT | 2147483647 | √ | null |
|
|
||
| last_statement_latency | VARCHAR | 11 | √ | null |
|
|
||
| current_memory | VARCHAR | 11 | √ | null |
|
|
||
| last_wait | VARCHAR | 128 | √ | null |
|
|
||
| last_wait_latency | VARCHAR | 13 | √ | null |
|
|
||
| source | VARCHAR | 64 | √ | null |
|
|
||
| trx_latency | VARCHAR | 11 | √ | null |
|
|
||
| trx_state | enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') | 11 | √ | null |
|
|
||
| trx_autocommit | enum('YES', 'NO') | 3 | √ | null |
|
|
||
| pid | VARCHAR | 1024 | √ | null |
|
|
||
| program_name | VARCHAR | 1024 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
