2
select * from INNODB_LOCK_WAITS;
3
REQUESTING_TRX_ID REQUESTED_LOCK_ID BLOCKING_TRX_ID BLOCKING_LOCK_ID
4
show create table INNODB_LOCK_WAITS;
6
INNODB_LOCK_WAITS CREATE TABLE `innodb_lock_waits` (
7
`REQUESTING_TRX_ID` varchar(64) NOT NULL DEFAULT '',
8
`REQUESTED_LOCK_ID` varchar(64) NOT NULL DEFAULT '',
9
`BLOCKING_TRX_ID` varchar(64) NOT NULL DEFAULT '',
10
`BLOCKING_LOCK_ID` varchar(64) NOT NULL DEFAULT ''
11
) ENGINE=FunctionEngine