table contains current transaction events, one row per thread
showing the current status of the thread's most recent
monitored transaction event. For example:
SELECT * FROM events_transactions_current LIMIT 1\G*************************** 1. row *************************** THREAD_ID: 26 EVENT_ID: 7 END_EVENT_ID: NULL EVENT_NAME: transaction STATE: ACTIVE TRX_ID: NULL GTID: 3E11FA47-71CA-11E1-9E33-C80AA9429562:56 XID: NULL XA_STATE: NULL SOURCE: transaction.cc:150 TIMER_START: 420833537900000 TIMER_END: NULL TIMER_WAIT: NULL ACCESS_MODE: READ WRITE ISOLATION_LEVEL: REPEATABLE READ AUTOCOMMIT: NO NUMBER_OF_SAVEPOINTS: 0 NUMBER_OF_ROLLBACK_TO_SAVEPOINT: 0 NUMBER_OF_RELEASE_SAVEPOINT: 0 OBJECT_INSTANCE_BEGIN: NULL NESTING_EVENT_ID: 6 NESTING_EVENT_TYPE: STATEMENT
Of the tables that contain transaction event rows,
the most fundamental. Other tables that contain transaction
event rows are logically derived from the current events. For
tables are collections of the most recent transaction events,
up to a fixed number of rows.
For information about configuration of transaction event collection, see Section 25.11.7, “Performance Schema Transaction Tables”.
table has these columns:
The thread associated with the event and the thread current event number when the event starts. The
EVENT_IDvalues taken together uniquely identify the row. No two rows have the same pair of values.
This column is set to
NULLwhen the event starts and updated to the thread current event number when the event ends.
The name of the instrument from which the event was collected. This is a
NAMEvalue from the
setup_instrumentstable. Instrument names may have multiple parts and form a hierarchy, as discussed in Section 25.6, “Performance Schema Instrument Naming Conventions”.
The GTID column contains the value of
gtid_next, which can be one of
AUTOMATIC, or a GTID using the format
UUID:NUMBER. For transactions that use
gtid_next=AUTOMATIC, which is all normal client transactions, the GTID column changes when the transaction commits and the actual GTID is assigned. If
ON_PERMISSIVE, the GTID column changes to the transaction's GTID. If
OFF_PERMISSIVE, the GTID column changes to
The components of the XA transaction identifier. They have the format described in Section 220.127.116.11, “XA Transaction SQL Syntax”.
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. This enables you to check the source to determine exactly what code is involved.
Timing information for the event. The unit for these values is picoseconds (trillionths of a second). The
TIMER_ENDvalues indicate when event timing started and ended.
TIMER_WAITis the event elapsed time (duration).
If an event has not finished,
TIMER_ENDis the current timer value and
TIMER_WAITis the time elapsed so far (
If an event is produced from an instrument that has
TIMED = NO, timing information is not collected, and
For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 25.4.1, “Performance Schema Event Timing”.
The transaction access mode. The value is
Whether autcommit mode was enabled when the transaction started.
EVENT_IDvalue of the event within which this event is nested.
The nesting event type. The value is
TRANSACTIONwill not appear because transactions cannot be nested.)