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 | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1485067510000 | 1485075636000 | 8126000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1485164116000 | 1485184896000 | 20780000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1485583728000 | 1485590072000 | 6344000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1485690687000 | 1485696486000 | 5799000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1470080787000 | 1470788337000 | 707550000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1478334145000 | 1478343233000 | 9088000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1478418257000 | 1478448585000 | 30328000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1478484748000 | 1479173139000 | 688391000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1481708846000 | 1481770458000 | 61612000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484377629000 | 1484388928000 | 11299000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422169684621056 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1341149266000 | 1341411294000 | 262028000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
7209 | 6 | 6 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411078272855000 | 411078315872000 | 43017000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
7209 | 14 | 14 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411082095517000 | 411082254085000 | 158568000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 13 | STATEMENT | |
7209 | 16 | 16 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411082870327000 | 411083279107000 | 408780000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 15 | STATEMENT | |
7209 | 18 | 18 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411083980520000 | 411084246564000 | 266044000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 17 | STATEMENT | |
7209 | 20 | 20 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411085417224000 | 411085530843000 | 113619000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 19 | STATEMENT | |
7209 | 23 | 23 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411090017136000 | 411090135365000 | 118229000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
7209 | 25 | 25 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411090622612000 | 411090728878000 | 106266000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 24 | STATEMENT | |
7209 | 27 | 27 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411091161962000 | 411091268181000 | 106219000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
7209 | 29 | 29 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411091990010000 | 411092466975000 | 476965000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 28 | STATEMENT | |
7209 | 31 | 31 | transaction | COMMITTED | 422169684621928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411093221959000 | 411093794465000 | 572506000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 30 | STATEMENT | |
7211 | 6 | 6 | transaction | COMMITTED | 422169684622800 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 411122708546000 | 411122780597000 | 72051000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|