| wait_started |
datetime
|
|
|
|
| wait_age |
time /* mariadb-5.3 */
|
|
|
|
| wait_age_secs |
bigint(21)
|
|
|
|
| locked_table |
varchar(1024)
|
utf8mb3_general_ci
|
|
|
| locked_index |
varchar(1024)
|
utf8mb3_general_ci
|
|
|
| locked_type |
enum('RECORD', 'TABLE')
|
utf8mb3_general_ci
|
|
|
| waiting_trx_id |
bigint(21)
|
|
|
|
| waiting_trx_started |
datetime
|
|
|
|
| waiting_trx_age |
time /* mariadb-5.3 */
|
|
|
|
| waiting_trx_rows_locked |
bigint(21)
|
|
|
|
| waiting_trx_rows_modified |
bigint(21)
|
|
|
|
| waiting_pid |
bigint(21)
|
|
|
|
| waiting_query |
longtext
|
utf8mb3_general_ci
|
|
|
| waiting_lock_id |
varchar(81)
|
utf8mb3_general_ci
|
|
|
| waiting_lock_mode |
enum('S', 'S, GAP', 'X', 'X, GAP', 'IS', 'IS, GAP', 'IX', 'IX, GAP', 'AUTO_INC')
|
utf8mb3_general_ci
|
|
|
| blocking_trx_id |
bigint(21)
|
|
|
|
| blocking_pid |
bigint(21)
|
|
|
|
| blocking_query |
longtext
|
utf8mb3_general_ci
|
|
|
| blocking_lock_id |
varchar(81)
|
utf8mb3_general_ci
|
|
|
| blocking_lock_mode |
enum('S', 'S, GAP', 'X', 'X, GAP', 'IS', 'IS, GAP', 'IX', 'IX, GAP', 'AUTO_INC')
|
utf8mb3_general_ci
|
|
|
| blocking_trx_started |
datetime
|
|
|
|
| blocking_trx_age |
time /* mariadb-5.3 */
|
|
|
|
| blocking_trx_rows_locked |
bigint(21)
|
|
|
|
| blocking_trx_rows_modified |
bigint(21)
|
|
|
|
| sql_kill_blocking_query |
varchar(32)
|
utf8mb3_general_ci
|
|
|
| sql_kill_blocking_connection |
varchar(26)
|
utf8mb3_general_ci
|
|
|