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 | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1523600228000 | 1523608504000 | 8276000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1523687089000 | 1523695259000 | 8170000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1524090204000 | 1524096601000 | 6397000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1524192377000 | 1524197864000 | 5487000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1509856223000 | 1510512751000 | 656528000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1517745970000 | 1517750645000 | 4675000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1517821112000 | 1517847445000 | 26333000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1517879240000 | 1518193313000 | 314073000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1520581457000 | 1520600362000 | 18905000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421630500715112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1522971993000 | 1522982165000 | 10172000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421630500714240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1394250050000 | 1394572998000 | 322948000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1473 | 6 | 6 | transaction | COMMITTED | 421630500719472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70727759688000 | 70727801691000 | 42003000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
1473 | 12 | 12 | transaction | COMMITTED | 421630500719472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70736791318000 | 70736999453000 | 208135000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
1473 | 15 | 15 | transaction | COMMITTED | 421630500719472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70738038720000 | 70738669445000 | 630725000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
1473 | 19 | 19 | transaction | COMMITTED | 421630500719472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70739825907000 | 70739954557000 | 128650000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
1473 | 21 | 21 | transaction | COMMITTED | 421630500719472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70740393745000 | 70740971324000 | 577579000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
1473 | 23 | 23 | transaction | COMMITTED | 421630500719472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70741579338000 | 70741841155000 | 261817000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
1473 | 26 | 26 | transaction | COMMITTED | 421630500719472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70762206428000 | 70763243986000 | 1037558000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
1478 | 32 | 32 | transaction | COMMITTED | 421630500717728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70936293285000 | 70936961063000 | 667778000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
1478 | 11 | 11 | transaction | COMMITTED | 421630500717728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70883122895000 | 70883197155000 | 74260000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
1478 | 15 | 15 | transaction | COMMITTED | 421630500717728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70884233737000 | 70884343936000 | 110199000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
1478 | 17 | 17 | transaction | COMMITTED | 421630500717728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70884715524000 | 70885164255000 | 448731000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
1478 | 19 | 19 | transaction | COMMITTED | 421630500717728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70885678009000 | 70885899274000 | 221265000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
1478 | 21 | 21 | transaction | COMMITTED | 421630500717728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70886539890000 | 70886634438000 | 94548000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
1478 | 24 | 24 | transaction | COMMITTED | 421630500717728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 70922060186000 | 70922294409000 | 234223000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT |
|