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 | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1566339298000 | 1566347293000 | 7995000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1566430439000 | 1566439333000 | 8894000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1566850070000 | 1566869833000 | 19763000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1566966856000 | 1566972747000 | 5891000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1552673160000 | 1553283066000 | 609906000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1560379380000 | 1560390050000 | 10670000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1560466071000 | 1560499693000 | 33622000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1560535414000 | 1560861086000 | 325672000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1563269248000 | 1563292731000 | 23483000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1565735639000 | 1565745775000 | 10136000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421647313057536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1411705521000 | 1411939689000 | 234168000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2689 | 6 | 6 | transaction | COMMITTED | 421647313058408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 180183051254000 | 180183095865000 | 44611000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|