|
THREAD_ID
|
bigint
|
|
|
|
|
EVENT_ID
|
bigint
|
|
|
|
|
END_EVENT_ID
|
bigint
|
|
|
|
|
EVENT_NAME
|
varchar(128)
|
utf8mb4_0900_ai_ci
|
|
|
|
STATE
|
enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')
|
utf8mb4_0900_ai_ci
|
|
|
|
TRX_ID
|
bigint
|
|
|
|
|
GTID
|
varchar(64)
|
utf8mb4_0900_ai_ci
|
|
|
|
XID_FORMAT_ID
|
int
|
|
|
|
|
XID_GTRID
|
varchar(130)
|
utf8mb4_0900_ai_ci
|
|
|
|
XID_BQUAL
|
varchar(130)
|
utf8mb4_0900_ai_ci
|
|
|
|
XA_STATE
|
varchar(64)
|
utf8mb4_0900_ai_ci
|
|
|
|
SOURCE
|
varchar(64)
|
utf8mb4_0900_ai_ci
|
|
|
|
TIMER_START
|
bigint
|
|
|
|
|
TIMER_END
|
bigint
|
|
|
|
|
TIMER_WAIT
|
bigint
|
|
|
|
|
ACCESS_MODE
|
enum('READ ONLY', 'READ WRITE')
|
utf8mb4_0900_ai_ci
|
|
|
|
ISOLATION_LEVEL
|
varchar(64)
|
utf8mb4_0900_ai_ci
|
|
|
|
AUTOCOMMIT
|
enum('YES', 'NO')
|
utf8mb4_0900_ai_ci
|
|
|
|
NUMBER_OF_SAVEPOINTS
|
bigint
|
|
|
|
|
NUMBER_OF_ROLLBACK_TO_SAVEPOINT
|
bigint
|
|
|
|
|
NUMBER_OF_RELEASE_SAVEPOINT
|
bigint
|
|
|
|
|
OBJECT_INSTANCE_BEGIN
|
bigint
|
|
|
|
|
NESTING_EVENT_ID
|
bigint
|
|
|
|
|
NESTING_EVENT_TYPE
|
enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')
|
utf8mb4_0900_ai_ci
|
|
|
`sys`.`schema_unused_indexes`