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 | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1772169855000 | 1772182460000 | 12605000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1772288967000 | 1772301595000 | 12628000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1772888196000 | 1772898637000 | 10441000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1773028650000 | 1773037433000 | 8783000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1733615398000 | 1734912809000 | 1297411000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1759041598000 | 1759070349000 | 28751000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1759256483000 | 1759332665000 | 76182000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1759423762000 | 1760343273000 | 919511000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1767025471000 | 1767062183000 | 36712000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1771210071000 | 1771229301000 | 19230000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422023192770304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1539660143000 | 1540059124000 | 398981000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2957 | 7 | 7 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 518610765469000 | 518611146384000 | 380915000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 6 | STATEMENT | |
2957 | 10 | 10 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 518613647641000 | 518615500533000 | 1852892000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 9 | STATEMENT | |
2957 | 12 | 12 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 518617035729000 | 518617371439000 | 335710000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
2957 | 18 | 18 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 518653519496000 | 518653725520000 | 206024000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 17 | STATEMENT | |
2959 | 6 | 6 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 518654592851000 | 518654632343000 | 39492000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|