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 | 421247948704360 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1542538234000 | 1542543943000 | 5709000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421247948703488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1386314255000 | 1386617417000 | 303162000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
7666 | 0 | 40 | transaction | COMMITTED | 421247948706976 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 395356182584000 | 395356463944000 | 281360000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 39 | STATEMENT | |
8095 | 38 | 38 | transaction | COMMITTED | 421247948705232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 415308141710000 | 415308414169000 | 272459000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
5956 | 0 | 47 | transaction | COMMITTED | 421247948707848 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 296416444405000 | 296416491934000 | 47529000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
8097 | 27 | 27 | transaction | COMMITTED | 421247948704360 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 415175746919000 | 415176550356000 | 803437000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
5958 | 0 | 47 | transaction | COMMITTED | 421247948705232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 296597241326000 | 296597276028000 | 34702000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
8099 | 27 | 27 | transaction | COMMITTED | 421247948706104 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 415196866358000 | 415198010573000 | 1144215000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
7030 | 0 | 25 | transaction | COMMITTED | 421247948706104 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 361635462953000 | 361635712045000 | 249092000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 24 | STATEMENT | |
8101 | 6 | 6 | transaction | COMMITTED | 421247948706976 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 415303767808000 | 415303809448000 | 41640000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|