1
THREAD_ID
bigint(20)
UNSIGNED
No
None
The thread associated with the event.
2
EVENT_ID
bigint(20)
UNSIGNED
No
None
The event id associated with the event.
3
END_EVENT_ID
bigint(20)
UNSIGNED
Yes
NULL
This column is set to NULL when the event starts and updated to the thread current event number when the event ends.
4
EVENT_NAME
varchar(128)
utf8mb3_general_ci
No
None
The name of the instrument from which the event was collected. This is a NAME value from the setup_instruments table.
5
STATE
enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')
utf8mb3_general_ci
Yes
NULL
The current transaction state. The value is ACTIVE (after START TRANSACTION or BEGIN), COMMITTED (after COMMIT), or ROLLED BACK (after ROLLBACK).
6
TRX_ID
bigint(20)
UNSIGNED
Yes
NULL
Unused.
7
GTID
varchar(64)
utf8mb3_general_ci
Yes
NULL
Transaction GTID, using the format DOMAIN-SERVER_ID-SEQUENCE_NO.
8
XID_FORMAT_ID
int(11)
Yes
NULL
XA transaction format ID for GTRID and BQUAL values.
9
XID_GTRID
varchar(130)
utf8mb3_general_ci
Yes
NULL
XA global transaction ID.
10
XID_BQUAL
varchar(130)
utf8mb3_general_ci
Yes
NULL
XA transaction branch qualifier.
11
XA_STATE
varchar(64)
utf8mb3_general_ci
Yes
NULL
The state of the XA transaction. The value is ACTIVE (after XA START), IDLE (after XA END), PREPARED (after XA PREPARE), ROLLED BACK (after XA ROLLBACK), or COMMITTED (after XA COMMIT).
12
SOURCE
varchar(64)
utf8mb3_general_ci
Yes
NULL
The name of the source file containing the instrumented code that produced the event and the line number in the file at which the instrumentation occurs.
13
TIMER_START
bigint(20)
UNSIGNED
Yes
NULL
The unit is picoseconds. When event timing started. NULL if event has no timing information.
14
TIMER_END
bigint(20)
UNSIGNED
Yes
NULL
The unit is picoseconds. When event timing ended. NULL if event has no timing information.
15
TIMER_WAIT
bigint(20)
UNSIGNED
Yes
NULL
The unit is picoseconds. Event duration. NULL if event has not timing information.
16
ACCESS_MODE
enum('READ ONLY', 'READ WRITE')
utf8mb3_general_ci
Yes
NULL
Transaction access mode.
17
ISOLATION_LEVEL
varchar(64)
utf8mb3_general_ci
Yes
NULL
Transaction isolation level. One of: REPEATABLE READ, READ COMMITTED, READ UNCOMMITTED, or SERIALIZABLE.
18
AUTOCOMMIT
enum('YES', 'NO')
utf8mb3_general_ci
No
None
Whether autcommit mode was enabled when the transaction started.
19
NUMBER_OF_SAVEPOINTS
bigint(20)
UNSIGNED
Yes
NULL
The number of SAVEPOINT statements issued during the transaction.
20
NUMBER_OF_ROLLBACK_TO_SAVEPOINT
bigint(20)
UNSIGNED
Yes
NULL
The number of ROLLBACK_TO_SAVEPOINT statements issued during the transaction.
21
NUMBER_OF_RELEASE_SAVEPOINT
bigint(20)
UNSIGNED
Yes
NULL
The number of RELEASE_SAVEPOINT statements issued during the transaction.
22
OBJECT_INSTANCE_BEGIN
bigint(20)
UNSIGNED
Yes
NULL
Unused.
23
NESTING_EVENT_ID
bigint(20)
UNSIGNED
Yes
NULL
The EVENT_ID value of the event within which this event is nested.
24
NESTING_EVENT_TYPE
enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')
utf8mb3_general_ci
Yes
NULL
The nesting event type.