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 | 421568033266280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1790548821000 | 1790557855000 | 9034000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421568033265408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1595954729000 | 1596323545000 | 368816000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
507 | 0 | 15 | transaction | COMMITTED | 421568033266280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 40422158112000 | 40422424238000 | 266126000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
1791 | 44 | 44 | transaction | COMMITTED | 421568033266280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148559444355000 | 148560897688000 | 1453333000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 43 | STATEMENT | |
509 | 0 | 9 | transaction | COMMITTED | 421568033266280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 40431171540000 | 40431444673000 | 273133000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT | |
1793 | 26 | 26 | transaction | COMMITTED | 421568033267152 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148511003095000 | 148511861792000 | 858697000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
511 | 0 | 20 | transaction | COMMITTED | 421568033266280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 40604137110000 | 40604386172000 | 249062000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 19 | STATEMENT | |
1795 | 6 | 6 | transaction | COMMITTED | 421568033268024 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148550719648000 | 148550763634000 | 43986000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|