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 | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1423813494000 | 1423821344000 | 7850000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1423893591000 | 1423901475000 | 7884000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1424296997000 | 1424303785000 | 6788000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1424393602000 | 1424399234000 | 5632000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1408303369000 | 1409009703000 | 706334000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1416725934000 | 1416730776000 | 4842000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1416803288000 | 1416830501000 | 27213000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1416861538000 | 1418098937000 | 1237399000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1420767487000 | 1420794173000 | 26686000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1423157238000 | 1423168854000 | 11616000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421112860329728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1268993528000 | 1269272688000 | 279160000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
689 | 36 | 36 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510409599538000 | 510409824889000 | 225351000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
689 | 12 | 12 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510272051443000 | 510272189346000 | 137903000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
689 | 15 | 15 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510273234112000 | 510273656363000 | 422251000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
689 | 19 | 19 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510274959425000 | 510275060900000 | 101475000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
689 | 21 | 21 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510275648992000 | 510276129207000 | 480215000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
689 | 23 | 23 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510276808141000 | 510277050851000 | 242710000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
689 | 26 | 26 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510283848923000 | 510284601172000 | 752249000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
689 | 30 | 30 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510399775146000 | 510399978544000 | 203398000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
689 | 32 | 32 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510404272950000 | 510404840298000 | 567348000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
689 | 34 | 34 | transaction | COMMITTED | 421112860330600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510407786215000 | 510407971909000 | 185694000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
691 | 6 | 6 | transaction | COMMITTED | 421112860331472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510417357310000 | 510417488451000 | 131141000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
693 | 3 | 3 | transaction | COMMITTED | 421112860333216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 510420779902000 | 510421112918000 | 333016000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT |
|