1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
use data_dictionary;
select * from INNODB_LOCKS;
LOCK_ID LOCK_TRX_ID LOCK_MODE LOCK_TYPE LOCK_TABLE LOCK_INDEX LOCK_SPACE LOCK_PAGE LOCK_REC LOCK_DATA
show create table INNODB_LOCKS;
Table Create Table
INNODB_LOCKS CREATE TABLE `INNODB_LOCKS` (
`LOCK_ID` VARCHAR(256) NOT NULL,
`LOCK_TRX_ID` VARCHAR(256) NOT NULL,
`LOCK_MODE` VARCHAR(256) NOT NULL,
`LOCK_TYPE` VARCHAR(256) NOT NULL,
`LOCK_TABLE` VARCHAR(256) NOT NULL,
`LOCK_INDEX` VARCHAR(256) NOT NULL,
`LOCK_SPACE` BIGINT NOT NULL,
`LOCK_PAGE` BIGINT NOT NULL,
`LOCK_REC` BIGINT NOT NULL,
`LOCK_DATA` VARCHAR(256) NOT NULL
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATION = FALSE
|