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 | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1873583670000 | 1873596598000 | 12928000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1873731699000 | 1873743930000 | 12231000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1874306569000 | 1874316508000 | 9939000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1874469500000 | 1874478702000 | 9202000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1835513782000 | 1836919289000 | 1405507000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1861993712000 | 1862010977000 | 17265000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1862190747000 | 1862256165000 | 65418000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1862352230000 | 1863656671000 | 1304441000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1868388214000 | 1868430800000 | 42586000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1872476182000 | 1872493992000 | 17810000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421948537689856 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1674701217000 | 1675000103000 | 298886000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
3197 | 6 | 6 | transaction | COMMITTED | 421948537690728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 338055538742000 | 338055593697000 | 54955000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|