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 | |
2383 | 6 | 6 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140204228122000 | 140204279701000 | 51579000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2383 | 14 | 14 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140208792445000 | 140208963167000 | 170722000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 13 | STATEMENT | |
2383 | 16 | 16 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140209727700000 | 140210167912000 | 440212000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 15 | STATEMENT | |
2383 | 18 | 18 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140211902219000 | 140212124764000 | 222545000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 17 | STATEMENT | |
2383 | 20 | 20 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140213683713000 | 140213784004000 | 100291000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 19 | STATEMENT | |
2383 | 23 | 23 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140219037810000 | 140219148823000 | 111013000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
2383 | 25 | 25 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140219506179000 | 140219600279000 | 94100000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 24 | STATEMENT | |
2383 | 27 | 27 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140219947053000 | 140220037236000 | 90183000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
2383 | 29 | 29 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140220539989000 | 140221113257000 | 573268000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 28 | STATEMENT | |
2383 | 31 | 31 | transaction | COMMITTED | 421143951764072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140221717741000 | 140222250433000 | 532692000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 30 | STATEMENT | |
2385 | 6 | 6 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140206234910000 | 140206269206000 | 34296000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2385 | 12 | 12 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140209230248000 | 140209338658000 | 108410000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
2385 | 15 | 15 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140210861239000 | 140211523925000 | 662686000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
2385 | 19 | 19 | transaction | COMMITTED | 421143951764944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 140213394881000 | 140213508463000 | 113582000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT |
|