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 | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1948187702000 | 1948219626000 | 31924000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1948501356000 | 1948549612000 | 48256000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1950065257000 | 1950092892000 | 27635000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1950429023000 | 1950453854000 | 24831000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1896400610000 | 1898132850000 | 1732240000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1923841224000 | 1923871361000 | 30137000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1924162775000 | 1924255083000 | 92308000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1924383733000 | 1928056091000 | 3672358000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1937520839000 | 1937597579000 | 76740000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1945911313000 | 1945951774000 | 40461000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421302185232128 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1726131423000 | 1726390795000 | 259372000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
3845 | 6 | 6 | transaction | COMMITTED | 421302185233000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 430862107154000 | 430862152701000 | 45547000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|