1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
use data_dictionary;
select * from INNODB_TRX;
TRX_ID TRX_STATE TRX_STARTED TRX_REQUESTED_LOCK_ID TRX_WAIT_STARTED TRX_WEIGHT TRX_DRIZZLE_THREAD_ID TRX_QUERY
show create table INNODB_TRX;
Table Create Table
INNODB_TRX CREATE TABLE `INNODB_TRX` (
`TRX_ID` varchar(256) NOT NULL,
`TRX_STATE` varchar(256) NOT NULL,
`TRX_STARTED` bigint NOT NULL,
`TRX_REQUESTED_LOCK_ID` varchar(256) NOT NULL,
`TRX_WAIT_STARTED` bigint NOT NULL,
`TRX_WEIGHT` bigint NOT NULL,
`TRX_DRIZZLE_THREAD_ID` bigint NOT NULL,
`TRX_QUERY` varchar(256) NOT NULL
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
|