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 | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1934759397000 | 1934772007000 | 12610000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1934901767000 | 1934917927000 | 16160000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1935502727000 | 1935512695000 | 9968000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1935665678000 | 1935675054000 | 9376000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1898417781000 | 1899935507000 | 1517726000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1921555437000 | 1921571666000 | 16229000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1921742342000 | 1921805285000 | 62943000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1921891273000 | 1924319386000 | 2428113000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1929130478000 | 1929198019000 | 67541000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1933743050000 | 1933765915000 | 22865000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421909360793344 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1739647208000 | 1739943635000 | 296427000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1081 | 33 | 33 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60155401205000 | 60155606035000 | 204830000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
1081 | 35 | 35 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60157217653000 | 60157577720000 | 360067000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 34 | STATEMENT | |
1081 | 37 | 37 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60158182349000 | 60158484162000 | 301813000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 36 | STATEMENT | |
1081 | 92 | 92 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60273384240000 | 60273591583000 | 207343000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 91 | STATEMENT | |
1081 | 94 | 94 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60277951725000 | 60278585980000 | 634255000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 93 | STATEMENT | |
1081 | 96 | 96 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60281688172000 | 60281927921000 | 239749000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 95 | STATEMENT | |
1081 | 98 | 98 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60286662784000 | 60286886169000 | 223385000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 97 | STATEMENT | |
1081 | 100 | 100 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60336171477000 | 60336313195000 | 141718000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 99 | STATEMENT | |
1081 | 29 | 29 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60154169749000 | 60154356699000 | 186950000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 28 | STATEMENT | |
1081 | 31 | 31 | transaction | COMMITTED | 421909360795960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60154790596000 | 60154979489000 | 188893000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 30 | STATEMENT | |
1082 | 3 | 3 | transaction | COMMITTED | 421909360794216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60115139940000 | 60116594158000 | 1454218000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
1084 | 6 | 6 | transaction | COMMITTED | 421909360795088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60136636912000 | 60136681985000 | 45073000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
1084 | 12 | 12 | transaction | COMMITTED | 421909360795088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60140909978000 | 60141042499000 | 132521000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
1084 | 15 | 15 | transaction | COMMITTED | 421909360795088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 60141799848000 | 60142216968000 | 417120000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT |
|