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 | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1827783956000 | 1827797610000 | 13654000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1827946516000 | 1827962127000 | 15611000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1828651127000 | 1828663130000 | 12003000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1828837671000 | 1828847021000 | 9350000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1788599358000 | 1790167006000 | 1567648000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1814716247000 | 1814736308000 | 20061000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1814926800000 | 1814993936000 | 67136000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1815137868000 | 1816056734000 | 918866000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1822206363000 | 1822249600000 | 43237000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421210991200872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1826698098000 | 1826716404000 | 18306000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421210991200000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1613606055000 | 1613854089000 | 248034000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
11983 | 73 | 73 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619934405065000 | 619934440111000 | 35046000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 72 | STATEMENT | |
11983 | 75 | 75 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619935034829000 | 619935064336000 | 29507000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 74 | STATEMENT | |
11983 | 77 | 77 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619935562820000 | 619935595388000 | 32568000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 76 | STATEMENT | |
11983 | 79 | 79 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619936129816000 | 619936162798000 | 32982000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 78 | STATEMENT | |
11983 | 84 | 84 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619975647102000 | 619976685658000 | 1038556000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 83 | STATEMENT | |
11983 | 86 | 86 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619979703084000 | 619979992931000 | 289847000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 85 | STATEMENT | |
11983 | 88 | 88 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619981325416000 | 619981552940000 | 227524000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 87 | STATEMENT | |
11983 | 67 | 67 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619932329300000 | 619932379955000 | 50655000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 66 | STATEMENT | |
11983 | 69 | 69 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619933031771000 | 619933062045000 | 30274000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 68 | STATEMENT | |
11983 | 71 | 71 | transaction | COMMITTED | 421210991203488 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619933894958000 | 619933948120000 | 53162000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 70 | STATEMENT | |
11985 | 6 | 6 | transaction | COMMITTED | 421210991201744 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619918866313000 | 619918919644000 | 53331000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
11985 | 12 | 12 | transaction | COMMITTED | 421210991201744 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619925821000000 | 619925977746000 | 156746000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
11985 | 15 | 15 | transaction | COMMITTED | 421210991201744 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619926596028000 | 619927003120000 | 407092000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
11985 | 19 | 19 | transaction | COMMITTED | 421210991201744 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 619928446365000 | 619928646638000 | 200273000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT |
|