1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
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 TRX_OPERATION_STATE TRX_TABLES_LOCKED TRX_LOCK_STRUCTS TRX_LOCK_MEMORY_BYTES TRX_ROWS_LOCKED TRX_ROWS_MODIFIED TRX_CONCURRENCY_TICKETS TRX_ISOLATION_LEVEL TRX_UNIQUE_CHECKS TRX_FOREIGN_KEY_CHECKS TRX_LAST_FOREIGN_KEY_ERROR TRX_ADAPTIVE_HASH_LATCHED TRX_ADAPTIVE_HASH_TIMEOUT
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(1024) DEFAULT NULL,
`TRX_OPERATION_STATE` VARCHAR(64) DEFAULT NULL,
`TRX_TABLES_LOCKED` BIGINT NOT NULL,
`TRX_LOCK_STRUCTS` BIGINT NOT NULL,
`TRX_LOCK_MEMORY_BYTES` BIGINT NOT NULL,
`TRX_ROWS_LOCKED` BIGINT NOT NULL,
`TRX_ROWS_MODIFIED` BIGINT NOT NULL,
`TRX_CONCURRENCY_TICKETS` BIGINT NOT NULL,
`TRX_ISOLATION_LEVEL` VARCHAR(16) NOT NULL,
`TRX_UNIQUE_CHECKS` BIGINT NOT NULL,
`TRX_FOREIGN_KEY_CHECKS` BIGINT NOT NULL,
`TRX_LAST_FOREIGN_KEY_ERROR` VARCHAR(256) DEFAULT NULL,
`TRX_ADAPTIVE_HASH_LATCHED` BIGINT NOT NULL,
`TRX_ADAPTIVE_HASH_TIMEOUT` BIGINT NOT NULL
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER 'SYSTEM'
use test;
create table t1 (a int);
start transaction;
select TRX_STATE,TRX_QUERY from data_dictionary.INNODB_TRX;
TRX_STATE TRX_QUERY
RUNNING NULL
commit;
commit;
use test;
drop table t1;
|