67 lines
2.6 KiB
Plaintext
67 lines
2.6 KiB
Plaintext
DESC sys.innodb_lock_waits;
|
|
Field Type Null Key Default Extra
|
|
wait_started datetime YES NULL
|
|
wait_age time YES NULL
|
|
wait_age_secs bigint(21) YES NULL
|
|
locked_table mediumtext YES NULL
|
|
locked_table_schema varchar(64) YES NULL
|
|
locked_table_name varchar(64) YES NULL
|
|
locked_table_partition varchar(64) YES NULL
|
|
locked_table_subpartition varchar(64) YES NULL
|
|
locked_index varchar(64) YES NULL
|
|
locked_type varchar(32) NO NULL
|
|
waiting_trx_id varchar(18) NO
|
|
waiting_trx_started datetime NO 0000-00-00 00:00:00
|
|
waiting_trx_age time YES NULL
|
|
waiting_trx_rows_locked bigint(22) unsigned NO 0
|
|
waiting_trx_rows_modified bigint(22) unsigned NO 0
|
|
waiting_pid bigint(22) unsigned NO 0
|
|
waiting_query longtext YES NULL
|
|
waiting_lock_id varchar(128) NO NULL
|
|
waiting_lock_mode varchar(32) NO NULL
|
|
blocking_trx_id varchar(18) NO
|
|
blocking_pid bigint(22) unsigned NO 0
|
|
blocking_query longtext YES NULL
|
|
blocking_lock_id varchar(128) NO NULL
|
|
blocking_lock_mode varchar(32) NO NULL
|
|
blocking_trx_started datetime NO 0000-00-00 00:00:00
|
|
blocking_trx_age time YES NULL
|
|
blocking_trx_rows_locked bigint(22) unsigned NO 0
|
|
blocking_trx_rows_modified bigint(22) unsigned NO 0
|
|
sql_kill_blocking_query varchar(33) NO
|
|
sql_kill_blocking_connection varchar(27) NO
|
|
SELECT * FROM sys.innodb_lock_waits;
|
|
DESC sys.x$innodb_lock_waits;
|
|
Field Type Null Key Default Extra
|
|
wait_started datetime YES NULL
|
|
wait_age time YES NULL
|
|
wait_age_secs bigint(21) YES NULL
|
|
locked_table mediumtext YES NULL
|
|
locked_table_schema varchar(64) YES NULL
|
|
locked_table_name varchar(64) YES NULL
|
|
locked_table_partition varchar(64) YES NULL
|
|
locked_table_subpartition varchar(64) YES NULL
|
|
locked_index varchar(64) YES NULL
|
|
locked_type varchar(32) NO NULL
|
|
waiting_trx_id varchar(18) NO
|
|
waiting_trx_started datetime NO 0000-00-00 00:00:00
|
|
waiting_trx_age time YES NULL
|
|
waiting_trx_rows_locked bigint(22) unsigned NO 0
|
|
waiting_trx_rows_modified bigint(22) unsigned NO 0
|
|
waiting_pid bigint(22) unsigned NO 0
|
|
waiting_query varchar(1024) YES NULL
|
|
waiting_lock_id varchar(128) NO NULL
|
|
waiting_lock_mode varchar(32) NO NULL
|
|
blocking_trx_id varchar(18) NO
|
|
blocking_pid bigint(22) unsigned NO 0
|
|
blocking_query varchar(1024) YES NULL
|
|
blocking_lock_id varchar(128) NO NULL
|
|
blocking_lock_mode varchar(32) NO NULL
|
|
blocking_trx_started datetime NO 0000-00-00 00:00:00
|
|
blocking_trx_age time YES NULL
|
|
blocking_trx_rows_locked bigint(22) unsigned NO 0
|
|
blocking_trx_rows_modified bigint(22) unsigned NO 0
|
|
sql_kill_blocking_query varchar(33) NO
|
|
sql_kill_blocking_connection varchar(27) NO
|
|
SELECT * FROM sys.x$innodb_lock_waits;
|