|
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
|
varchar(1024)
|
utf8mb3_general_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
|
varchar(1024)
|
utf8mb3_general_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
|
|
|
`sys`.`schema_unused_indexes`