Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
| Campo | Tipo | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| wait_started | datetime | YES | |||
| wait_age | time /* mariadb-5.3 */ | YES | |||
| wait_age_secs | bigint(21) | YES | |||
| locked_table | varchar(1024) | NO | |||
| locked_index | varchar(1024) | YES | |||
| locked_type | enum('RECORD','TABLE') | NO | |||
| waiting_trx_id | bigint(21) unsigned | NO | |||
| waiting_trx_started | datetime | NO | |||
| waiting_trx_age | time /* mariadb-5.3 */ | YES | |||
| waiting_trx_rows_locked | bigint(21) unsigned | NO | |||
| waiting_trx_rows_modified | bigint(21) unsigned | NO | |||
| waiting_pid | bigint(21) unsigned | NO | |||
| waiting_query | varchar(1024) | YES | |||
| waiting_lock_id | varchar(81) | NO | |||
| waiting_lock_mode | enum('S','S,GAP','X','X,GAP','IS','IS,GAP','IX','IX,GAP','AUTO_INC') | NO | |||
| blocking_trx_id | bigint(21) unsigned | NO | |||
| blocking_pid | bigint(21) unsigned | NO | |||
| blocking_query | varchar(1024) | YES | |||
| blocking_lock_id | varchar(81) | NO | |||
| blocking_lock_mode | enum('S','S,GAP','X','X,GAP','IS','IS,GAP','IX','IX,GAP','AUTO_INC') | NO | |||
| blocking_trx_started | datetime | NO | |||
| blocking_trx_age | time /* mariadb-5.3 */ | YES | |||
| blocking_trx_rows_locked | bigint(21) unsigned | NO | |||
| blocking_trx_rows_modified | bigint(21) unsigned | NO | |||
| sql_kill_blocking_query | varchar(32) | YES | |||
| sql_kill_blocking_connection | varchar(26) | YES |