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 | |
4361 | 6 | 6 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 723112134947000 | 723112178668000 | 43721000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
4361 | 12 | 12 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 723115349037000 | 723115559812000 | 210775000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
4361 | 15 | 15 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 723116467469000 | 723117476671000 | 1009202000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
4361 | 19 | 19 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 723118873435000 | 723118985423000 | 111988000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
4361 | 21 | 21 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 723119665612000 | 723120235645000 | 570033000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
4361 | 23 | 23 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 723120846515000 | 723121073907000 | 227392000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
4361 | 27 | 27 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 723128331580000 | 723129098229000 | 766649000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
4363 | 6 | 6 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 723208719136000 | 723208762495000 | 43359000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|