Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| query | LONGTEXT | 2147483647 | √ | null |
|
|
||
| db | VARCHAR | 64 | √ | null |
|
|
||
| full_scan | VARCHAR | 1 |
|
|
||||
| exec_count | BIGINT UNSIGNED | 20 | null |
|
|
|||
| err_count | BIGINT UNSIGNED | 20 | null |
|
|
|||
| warn_count | BIGINT UNSIGNED | 20 | null |
|
|
|||
| total_latency | VARCHAR | 11 | √ | null |
|
|
||
| max_latency | VARCHAR | 11 | √ | null |
|
|
||
| avg_latency | VARCHAR | 11 | √ | null |
|
|
||
| lock_latency | VARCHAR | 11 | √ | null |
|
|
||
| cpu_latency | VARCHAR | 11 | √ | null |
|
|
||
| rows_sent | BIGINT UNSIGNED | 20 | null |
|
|
|||
| rows_sent_avg | DECIMAL | 21 | 0 |
|
|
|||
| rows_examined | BIGINT UNSIGNED | 20 | null |
|
|
|||
| rows_examined_avg | DECIMAL | 21 | 0 |
|
|
|||
| rows_affected | BIGINT UNSIGNED | 20 | null |
|
|
|||
| rows_affected_avg | DECIMAL | 21 | 0 |
|
|
|||
| tmp_tables | BIGINT UNSIGNED | 20 | null |
|
|
|||
| tmp_disk_tables | BIGINT UNSIGNED | 20 | null |
|
|
|||
| rows_sorted | BIGINT UNSIGNED | 20 | null |
|
|
|||
| sort_merge_passes | BIGINT UNSIGNED | 20 | null |
|
|
|||
| digest | VARCHAR | 64 | √ | null |
|
|
||
| first_seen | TIMESTAMP | 26 | null |
|
|
|||
| last_seen | TIMESTAMP | 26 | null |
|
|
Relationships
Close relationships within degrees of separation
