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 | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1462616177000 | 1462623456000 | 7279000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1462692474000 | 1462700143000 | 7669000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1463070258000 | 1463076679000 | 6421000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1463188979000 | 1463195145000 | 6166000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1448083370000 | 1448870626000 | 787256000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1456044320000 | 1456052752000 | 8432000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1456163816000 | 1456192128000 | 28312000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1456227335000 | 1457143397000 | 916062000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1459663597000 | 1459684211000 | 20614000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1462007807000 | 1462017035000 | 9228000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421143951763200 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1327355291000 | 1327630166000 | 274875000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
14419 | 8085 | 8085 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847402157706000 | 847402262325000 | 104619000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8084 | STATEMENT | |
14419 | 8087 | 8087 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847402643518000 | 847402818770000 | 175252000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8086 | STATEMENT | |
14419 | 8089 | 8089 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847403115864000 | 847403260232000 | 144368000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8088 | STATEMENT | |
14419 | 8071 | 8071 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847399380132000 | 847399507587000 | 127455000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8070 | STATEMENT | |
14419 | 8073 | 8073 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847399814356000 | 847399940580000 | 126224000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8072 | STATEMENT | |
14419 | 8075 | 8075 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847400285229000 | 847400412454000 | 127225000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8074 | STATEMENT | |
14419 | 8077 | 8077 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847400719686000 | 847400856241000 | 136555000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8076 | STATEMENT | |
14419 | 8079 | 8079 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847401106013000 | 847401191128000 | 85115000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8078 | STATEMENT | |
14419 | 8081 | 8081 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847401442719000 | 847401526280000 | 83561000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8080 | STATEMENT | |
14419 | 8083 | 8083 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847401781666000 | 847401864834000 | 83168000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8082 | STATEMENT | |
14443 | 6 | 6 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 847402132851000 | 847402157915000 | 25064000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|