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 | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1772976742000 | 1772985090000 | 8348000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1773070834000 | 1773079331000 | 8497000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1773471055000 | 1773477494000 | 6439000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1773580140000 | 1773585959000 | 5819000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1755801712000 | 1756547005000 | 745293000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1765316568000 | 1765325327000 | 8759000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1765407477000 | 1765438738000 | 31261000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1765481377000 | 1766164272000 | 682895000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1768965534000 | 1768990571000 | 25037000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1772227664000 | 1772242065000 | 14401000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422005631350528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1591276225000 | 1592945387000 | 1669162000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
12413 | 6 | 6 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 691538800474000 | 691538840696000 | 40222000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|