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 | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1625240870000 | 1625253090000 | 12220000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1625360700000 | 1625372975000 | 12275000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1625965366000 | 1625975300000 | 9934000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1626124052000 | 1626133425000 | 9373000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1588672220000 | 1590121481000 | 1449261000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1612578401000 | 1612594577000 | 16176000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1612775707000 | 1612840599000 | 64892000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1612939106000 | 1614250587000 | 1311481000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1619983690000 | 1620043696000 | 60006000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1624150967000 | 1624168228000 | 17261000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421718036834048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1405042475000 | 1405455433000 | 412958000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
3431 | 6 | 6 | transaction | COMMITTED | 421718036834920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 391851669448000 | 391851720919000 | 51471000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|