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 | |
8245 | 36 | 36 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462812486621000 | 462813937833000 | 1451212000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
8245 | 38 | 38 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462838663592000 | 462838931495000 | 267903000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
8245 | 15 | 15 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462670589886000 | 462671111305000 | 521419000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
8245 | 19 | 19 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462672810850000 | 462672937837000 | 126987000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
8245 | 21 | 21 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462673617866000 | 462674151801000 | 533935000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
8245 | 23 | 23 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462674848925000 | 462675108926000 | 260001000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
8245 | 26 | 26 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462682356084000 | 462683127425000 | 771341000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
8245 | 30 | 30 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462801295165000 | 462801502336000 | 207171000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
8245 | 32 | 32 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462805582764000 | 462806177145000 | 594381000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
8245 | 34 | 34 | transaction | COMMITTED | 422005631351400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462809400843000 | 462809600656000 | 199813000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
8247 | 35 | 35 | transaction | COMMITTED | 422005631352272 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462828798448000 | 462829196711000 | 398263000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 34 | STATEMENT | |
8247 | 37 | 37 | transaction | COMMITTED | 422005631352272 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462835027159000 | 462835737851000 | 710692000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 36 | STATEMENT | |
8247 | 39 | 39 | transaction | COMMITTED | 422005631352272 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462841297881000 | 462841588771000 | 290890000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 38 | STATEMENT | |
8247 | 41 | 41 | transaction | COMMITTED | 422005631352272 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 462842887012000 | 462843061112000 | 174100000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 40 | STATEMENT |
|