Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| wait_started | DATETIME | 19 | √ | null |
|
|
||
| wait_age | TIME | 8 | √ | null |
|
|
||
| wait_age_secs | BIGINT | 19 | √ | null |
|
|
||
| locked_table | MEDIUMTEXT | 16777215 | √ | null |
|
|
||
| locked_table_schema | VARCHAR | 64 | √ | null |
|
|
||
| locked_table_name | VARCHAR | 64 | √ | null |
|
|
||
| locked_table_partition | VARCHAR | 64 | √ | null |
|
|
||
| locked_table_subpartition | VARCHAR | 64 | √ | null |
|
|
||
| locked_index | VARCHAR | 64 | √ | null |
|
|
||
| locked_type | VARCHAR | 32 | null |
|
|
|||
| waiting_trx_id | BIGINT UNSIGNED | 20 | 0 |
|
|
|||
| waiting_trx_started | DATETIME | 19 | 0000-00-00 00:00:00 |
|
|
|||
| waiting_trx_age | TIME | 8 | √ | null |
|
|
||
| waiting_trx_rows_locked | BIGINT UNSIGNED | 20 | 0 |
|
|
|||
| waiting_trx_rows_modified | BIGINT UNSIGNED | 20 | 0 |
|
|
|||
| waiting_pid | BIGINT UNSIGNED | 20 | 0 |
|
|
|||
| waiting_query | LONGTEXT | 2147483647 | √ | null |
|
|
||
| waiting_lock_id | VARCHAR | 128 | null |
|
|
|||
| waiting_lock_mode | VARCHAR | 32 | null |
|
|
|||
| blocking_trx_id | BIGINT UNSIGNED | 20 | 0 |
|
|
|||
| blocking_pid | BIGINT UNSIGNED | 20 | 0 |
|
|
|||
| blocking_query | LONGTEXT | 2147483647 | √ | null |
|
|
||
| blocking_lock_id | VARCHAR | 128 | null |
|
|
|||
| blocking_lock_mode | VARCHAR | 32 | null |
|
|
|||
| blocking_trx_started | DATETIME | 19 | 0000-00-00 00:00:00 |
|
|
|||
| blocking_trx_age | TIME | 8 | √ | null |
|
|
||
| blocking_trx_rows_locked | BIGINT UNSIGNED | 20 | 0 |
|
|
|||
| blocking_trx_rows_modified | BIGINT UNSIGNED | 20 | 0 |
|
|
|||
| sql_kill_blocking_query | VARCHAR | 33 |
|
|
||||
| sql_kill_blocking_connection | VARCHAR | 27 |
|
|
Relationships
Close relationships within degrees of separation
