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 | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1891381545000 | 1891396534000 | 14989000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1891532728000 | 1891547009000 | 14281000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1892271786000 | 1892283286000 | 11500000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1892459748000 | 1892470665000 | 10917000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1852812779000 | 1854069967000 | 1257188000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1879247042000 | 1879268985000 | 21943000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1879452833000 | 1879519506000 | 66673000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1879624880000 | 1880501556000 | 876676000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1885981274000 | 1886032998000 | 51724000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1890264443000 | 1890290641000 | 26198000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421317621896960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1699658184000 | 1700016104000 | 357920000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1657 | 6 | 6 | transaction | COMMITTED | 421317621897832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 333418897332000 | 333419097011000 | 199679000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
1659 | 6 | 6 | transaction | COMMITTED | 421317621898704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 333423372507000 | 333423422088000 | 49581000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|