DESC sys.innodb_lock_waits;
Field	Type	Null	Key	Default	Extra
wait_started	datetime	X		X	
wait_age	time	X		X	
wait_age_secs	bigint	X		X	
locked_table	mediumtext	X		X	
locked_table_schema	varchar(64)	X		X	
locked_table_name	varchar(64)	X		X	
locked_table_partition	varchar(64)	X		X	
locked_table_subpartition	varchar(64)	X		X	
locked_index	varchar(64)	X		X	
locked_type	varchar(32)	X		X	
waiting_trx_id	bigint unsigned	X		X	
waiting_trx_started	datetime	X		X	
waiting_trx_age	time	X		X	
waiting_trx_rows_locked	bigint unsigned	X		X	
waiting_trx_rows_modified	bigint unsigned	X		X	
waiting_pid	bigint unsigned	X		X	
waiting_query	longtext	X		X	
waiting_lock_id	varchar(128)	X		X	
waiting_lock_mode	varchar(32)	X		X	
blocking_trx_id	bigint unsigned	X		X	
blocking_pid	bigint unsigned	X		X	
blocking_query	longtext	X		X	
blocking_lock_id	varchar(128)	X		X	
blocking_lock_mode	varchar(32)	X		X	
blocking_trx_started	datetime	X		X	
blocking_trx_age	time	X		X	
blocking_trx_rows_locked	bigint unsigned	X		X	
blocking_trx_rows_modified	bigint unsigned	X		X	
sql_kill_blocking_query	varchar(32)	X		X	
sql_kill_blocking_connection	varchar(26)	X		X	
SELECT * FROM sys.innodb_lock_waits;
DESC sys.x$innodb_lock_waits;
Field	Type	Null	Key	Default	Extra
wait_started	datetime	X		X	
wait_age	time	X		X	
wait_age_secs	bigint	X		X	
locked_table	mediumtext	X		X	
locked_table_schema	varchar(64)	X		X	
locked_table_name	varchar(64)	X		X	
locked_table_partition	varchar(64)	X		X	
locked_table_subpartition	varchar(64)	X		X	
locked_index	varchar(64)	X		X	
locked_type	varchar(32)	X		X	
waiting_trx_id	bigint unsigned	X		X	
waiting_trx_started	datetime	X		X	
waiting_trx_age	time	X		X	
waiting_trx_rows_locked	bigint unsigned	X		X	
waiting_trx_rows_modified	bigint unsigned	X		X	
waiting_pid	bigint unsigned	X		X	
waiting_query	varchar(1024)	X		X	
waiting_lock_id	varchar(128)	X		X	
waiting_lock_mode	varchar(32)	X		X	
blocking_trx_id	bigint unsigned	X		X	
blocking_pid	bigint unsigned	X		X	
blocking_query	varchar(1024)	X		X	
blocking_lock_id	varchar(128)	X		X	
blocking_lock_mode	varchar(32)	X		X	
blocking_trx_started	datetime	X		X	
blocking_trx_age	time	X		X	
blocking_trx_rows_locked	bigint unsigned	X		X	
blocking_trx_rows_modified	bigint unsigned	X		X	
sql_kill_blocking_query	varchar(32)	X		X	
sql_kill_blocking_connection	varchar(26)	X		X	
SELECT * FROM sys.x$innodb_lock_waits;