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(21) unsigned	NO		0	
waiting_trx_rows_modified	bigint(21) unsigned	NO		0	
waiting_pid	bigint(21) 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(21) 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(21) unsigned	NO		0	
blocking_trx_rows_modified	bigint(21) unsigned	NO		0	
sql_kill_blocking_query	varchar(32)	NO			
sql_kill_blocking_connection	varchar(26)	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(21) unsigned	NO		0	
waiting_trx_rows_modified	bigint(21) unsigned	NO		0	
waiting_pid	bigint(21) 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(21) 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(21) unsigned	NO		0	
blocking_trx_rows_modified	bigint(21) unsigned	NO		0	
sql_kill_blocking_query	varchar(32)	NO			
sql_kill_blocking_connection	varchar(26)	NO			
SELECT * FROM sys.x$innodb_lock_waits;