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 | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1468040980000 | 1468048383000 | 7403000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1468118919000 | 1468127336000 | 8417000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1468504973000 | 1468511611000 | 6638000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1468610897000 | 1468616775000 | 5878000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1453477038000 | 1454223669000 | 746631000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1461694145000 | 1461699334000 | 5189000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1461768423000 | 1461798896000 | 30473000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1461835311000 | 1462765139000 | 929828000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1464920364000 | 1464945882000 | 25518000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1467424408000 | 1467437198000 | 12790000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421411257669376 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1326955185000 | 1327271461000 | 316276000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
10567 | 6 | 6 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 716994378617000 | 716994430802000 | 52185000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
10567 | 12 | 12 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 716998124168000 | 716998310571000 | 186403000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
10567 | 15 | 15 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 716999417651000 | 716999969247000 | 551596000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
10567 | 19 | 19 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717001682670000 | 717001805107000 | 122437000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
10567 | 21 | 21 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717002428213000 | 717002984656000 | 556443000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
10567 | 23 | 23 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717003702102000 | 717003992539000 | 290437000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
10567 | 27 | 27 | transaction | COMMITTED | 421411257670248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717016519599000 | 717021047718000 | 4528119000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
10569 | 6 | 6 | transaction | COMMITTED | 421411257671120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717009019082000 | 717009070586000 | 51504000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
10569 | 12 | 12 | transaction | COMMITTED | 421411257671120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717016721469000 | 717016848957000 | 127488000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
10569 | 15 | 15 | transaction | COMMITTED | 421411257671120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717017868969000 | 717018260192000 | 391223000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
10569 | 19 | 19 | transaction | COMMITTED | 421411257671120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717019768441000 | 717019910507000 | 142066000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
10569 | 21 | 21 | transaction | COMMITTED | 421411257671120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717020415382000 | 717020878968000 | 463586000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
10569 | 23 | 23 | transaction | COMMITTED | 421411257671120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717021711123000 | 717022038533000 | 327410000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
10569 | 26 | 26 | transaction | COMMITTED | 421411257671120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 717029918539000 | 717030671602000 | 753063000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT |
|