2
2
select * from INNODB_TRX;
3
TRX_ID TRX_STATE TRX_STARTED TRX_REQUESTED_LOCK_ID TRX_WAIT_STARTED TRX_WEIGHT TRX_DRIZZLE_THREAD_ID TRX_QUERY
3
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
4
4
show create table INNODB_TRX;
6
6
INNODB_TRX CREATE TABLE `INNODB_TRX` (
11
11
`TRX_WAIT_STARTED` BIGINT NOT NULL,
12
12
`TRX_WEIGHT` BIGINT NOT NULL,
13
13
`TRX_DRIZZLE_THREAD_ID` BIGINT NOT NULL,
14
`TRX_QUERY` VARCHAR(1024) DEFAULT NULL
14
`TRX_QUERY` VARCHAR(1024) DEFAULT NULL,
15
`TRX_OPERATION_STATE` VARCHAR(64) DEFAULT NULL,
16
`TRX_TABLES_LOCKED` BIGINT NOT NULL,
17
`TRX_LOCK_STRUCTS` BIGINT NOT NULL,
18
`TRX_LOCK_MEMORY_BYTES` BIGINT NOT NULL,
19
`TRX_ROWS_LOCKED` BIGINT NOT NULL,
20
`TRX_ROWS_MODIFIED` BIGINT NOT NULL,
21
`TRX_CONCURRENCY_TICKETS` BIGINT NOT NULL,
22
`TRX_ISOLATION_LEVEL` VARCHAR(16) NOT NULL,
23
`TRX_UNIQUE_CHECKS` BIGINT NOT NULL,
24
`TRX_FOREIGN_KEY_CHECKS` BIGINT NOT NULL,
25
`TRX_LAST_FOREIGN_KEY_ERROR` VARCHAR(256) DEFAULT NULL,
26
`TRX_ADAPTIVE_HASH_LATCHED` BIGINT NOT NULL,
27
`TRX_ADAPTIVE_HASH_TIMEOUT` BIGINT NOT NULL
15
28
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
added
removed
plugin/innobase/tests/r/innodb_trx.result
