events_transactions_history

2560 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
THREAD_ID BIGINT UNSIGNED 20 null
EVENT_ID BIGINT UNSIGNED 20 null
END_EVENT_ID BIGINT UNSIGNED 20 √ null
processlist.ID Implied ConstraintR
EVENT_NAME VARCHAR 128 null
STATE enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') 11 √ null
TRX_ID BIGINT UNSIGNED 20 √ null
processlist.ID Implied ConstraintR
GTID VARCHAR 64 √ null
XID_FORMAT_ID INT 10 √ null
XID_GTRID VARCHAR 130 √ null
XID_BQUAL VARCHAR 130 √ null
XA_STATE VARCHAR 64 √ null
SOURCE VARCHAR 64 √ null
TIMER_START BIGINT UNSIGNED 20 √ null
TIMER_END BIGINT UNSIGNED 20 √ null
TIMER_WAIT BIGINT UNSIGNED 20 √ null
ACCESS_MODE enum('READ ONLY', 'READ WRITE') 10 √ null
ISOLATION_LEVEL VARCHAR 64 √ null
AUTOCOMMIT enum('YES', 'NO') 3 null
NUMBER_OF_SAVEPOINTS BIGINT UNSIGNED 20 √ null
NUMBER_OF_ROLLBACK_TO_SAVEPOINT BIGINT UNSIGNED 20 √ null
NUMBER_OF_RELEASE_SAVEPOINT BIGINT UNSIGNED 20 √ null
OBJECT_INSTANCE_BEGIN BIGINT UNSIGNED 20 √ null
NESTING_EVENT_ID BIGINT UNSIGNED 20 √ null
processlist.ID Implied ConstraintR
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') 11 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc THREAD_ID + EVENT_ID

Relationships

Close relationships within degrees of separation