1 2 3 4 5 6 7 8 9 10 11 |
use data_dictionary; select * from INNODB_LOCK_WAITS; REQUESTING_TRX_ID REQUESTED_LOCK_ID BLOCKING_TRX_ID BLOCKING_LOCK_ID show create table INNODB_LOCK_WAITS; Table Create Table INNODB_LOCK_WAITS CREATE TABLE `INNODB_LOCK_WAITS` ( `REQUESTING_TRX_ID` VARCHAR(256) NOT NULL, `REQUESTED_LOCK_ID` VARCHAR(256) NOT NULL, `BLOCKING_TRX_ID` VARCHAR(256) NOT NULL, `BLOCKING_LOCK_ID` VARCHAR(256) NOT NULL ) ENGINE=FunctionEngine COLLATE = utf8_general_ci |