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 | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1887920036000 | 1887934263000 | 14227000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1888095680000 | 1888109091000 | 13411000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1888689789000 | 1888700384000 | 10595000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1888839428000 | 1888848479000 | 9051000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1850997998000 | 1852442612000 | 1444614000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1874684633000 | 1874707159000 | 22526000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1874917726000 | 1874981812000 | 64086000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1875073301000 | 1876472310000 | 1399009000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1881810970000 | 1881888688000 | 77718000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1885746980000 | 1885765387000 | 18407000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421591561869056 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1678914002000 | 1679282707000 | 368705000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
3769 | 6 | 6 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 656096001166000 | 656096045088000 | 43922000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
3769 | 12 | 12 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 656099153388000 | 656099291147000 | 137759000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
3769 | 15 | 15 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 656100262336000 | 656100828915000 | 566579000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
3769 | 19 | 19 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 656102185844000 | 656102284536000 | 98692000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
3769 | 21 | 21 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 656102816885000 | 656103294121000 | 477236000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
3769 | 23 | 23 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 656103907753000 | 656104142096000 | 234343000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
3769 | 26 | 26 | transaction | COMMITTED | 421591561869928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 656110954842000 | 656111713550000 | 758708000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
3771 | 6 | 6 | transaction | COMMITTED | 421591561870800 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 656144653878000 | 656144696067000 | 42189000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|