SELECT * FROM `events_transactions_current`
|
THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | STATE | TRX_ID | GTID | XID_FORMAT_ID | XID_GTRID | XID_BQUAL | XA_STATE | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | ACCESS_MODE | ISOLATION_LEVEL | AUTOCOMMIT | NUMBER_OF_SAVEPOINTS | NUMBER_OF_ROLLBACK_TO_SAVEPOINT | NUMBER_OF_RELEASE_SAVEPOINT | OBJECT_INSTANCE_BEGIN | NESTING_EVENT_ID | NESTING_EVENT_TYPE | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 14 | 14 | transaction | COMMITTED | 421727920441960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1797680372000 | 1797690817000 | 10445000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421727920441088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1591898076000 | 1592187310000 | 289234000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
4902 | 0 | 47 | transaction | COMMITTED | 421727920443704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 294106048251000 | 294106094800000 | 46549000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
5759 | 32 | 32 | transaction | COMMITTED | 421727920441960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 333222027595000 | 333223173720000 | 1146125000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
4904 | 0 | 94 | transaction | COMMITTED | 421727920445448 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 294140037700000 | 294140706532000 | 668832000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 93 | STATEMENT | |
5761 | 28 | NULL | transaction | ACTIVE | 421727920443704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 333222926541000 | 333223869072000 | 942531000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 27 | STATEMENT | |
4906 | 0 | 104 | transaction | COMMITTED | 421727920446320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 294230756010000 | 294230824991000 | 68981000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 103 | STATEMENT | |
5763 | 6 | 6 | transaction | COMMITTED | 421727920442832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 333221260604000 | 333221291427000 | 30823000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|