| wait_started |
datetime
|
|
|
|
| wait_age |
time
|
|
|
|
| wait_age_secs |
bigint
|
|
|
|
| locked_table |
mediumtext
|
utf8mb4_0900_ai_ci
|
|
|
| locked_table_schema |
varchar(64)
|
utf8mb4_0900_ai_ci
|
|
|
| locked_table_name |
varchar(64)
|
utf8mb4_0900_ai_ci
|
|
|
| locked_table_partition |
varchar(64)
|
utf8mb4_0900_ai_ci
|
|
|
| locked_table_subpartition |
varchar(64)
|
utf8mb4_0900_ai_ci
|
|
|
| locked_index |
varchar(64)
|
utf8mb4_0900_ai_ci
|
|
|
| locked_type |
varchar(32)
|
utf8mb4_0900_ai_ci
|
|
|
| waiting_trx_id |
bigint
|
|
|
|
| waiting_trx_started |
datetime
|
|
|
|
| waiting_trx_age |
time
|
|
|
|
| waiting_trx_rows_locked |
bigint
|
|
|
|
| waiting_trx_rows_modified |
bigint
|
|
|
|
| waiting_pid |
bigint
|
|
|
|
| waiting_query |
longtext
|
utf8mb4_0900_ai_ci
|
|
|
| waiting_lock_id |
varchar(128)
|
utf8mb4_0900_ai_ci
|
|
|
| waiting_lock_mode |
varchar(32)
|
utf8mb4_0900_ai_ci
|
|
|
| blocking_trx_id |
bigint
|
|
|
|
| blocking_pid |
bigint
|
|
|
|
| blocking_query |
longtext
|
utf8mb4_0900_ai_ci
|
|
|
| blocking_lock_id |
varchar(128)
|
utf8mb4_0900_ai_ci
|
|
|
| blocking_lock_mode |
varchar(32)
|
utf8mb4_0900_ai_ci
|
|
|
| blocking_trx_started |
datetime
|
|
|
|
| blocking_trx_age |
time
|
|
|
|
| blocking_trx_rows_locked |
bigint
|
|
|
|
| blocking_trx_rows_modified |
bigint
|
|
|
|
| sql_kill_blocking_query |
varchar(33)
|
utf8mb4_0900_ai_ci
|
|
|
| sql_kill_blocking_connection |
varchar(27)
|
utf8mb4_0900_ai_ci
|
|
|
