SELECT * FROM `events_transactions_history`
|
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 | 11 | 11 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1806554229000 | 1806572590000 | 18361000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1806723697000 | 1806747083000 | 23386000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1807573960000 | 1807588363000 | 14403000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1807780506000 | 1807792729000 | 12223000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1759520560000 | 1761155278000 | 1634718000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1786664856000 | 1786687182000 | 22326000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1786925280000 | 1787009742000 | 84462000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1787161609000 | 1789173591000 | 2011982000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1797611494000 | 1797704055000 | 92561000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1804919900000 | 1804955150000 | 35250000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421513708013312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1612739923000 | 1613216991000 | 477068000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2529 | 6 | 6 | transaction | COMMITTED | 421513708015056 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 165639704772000 | 165639751866000 | 47094000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2531 | 6 | 6 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 165628907242000 | 165628939804000 | 32562000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2531 | 9 | 9 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 165633133996000 | 165633233211000 | 99215000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT | |
2531 | 11 | 11 | transaction | COMMITTED | 421513708014184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 165633689211000 | 165634458673000 | 769462000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT |
|