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 | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1784571947000 | 1784586405000 | 14458000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1784750937000 | 1784770098000 | 19161000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1785615586000 | 1785625799000 | 10213000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1785793461000 | 1785806682000 | 13221000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1763135725000 | 1764082223000 | 946498000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1776064576000 | 1776075674000 | 11098000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1776214853000 | 1776251910000 | 37057000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1776307704000 | 1777461902000 | 1154198000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1780482253000 | 1780508468000 | 26215000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1783715276000 | 1783727631000 | 12355000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2395 | 38 | 38 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154559201827000 | 154559355708000 | 153881000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
2395 | 40 | 40 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154572946749000 | 154573230315000 | 283566000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 39 | STATEMENT | |
2395 | 15 | 15 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154413336294000 | 154414149705000 | 813411000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
2395 | 19 | 19 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154415661023000 | 154415799038000 | 138015000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
2395 | 21 | 21 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154416461708000 | 154417053732000 | 592024000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
2395 | 23 | 23 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154417814260000 | 154418094283000 | 280023000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
2395 | 27 | 27 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154427327348000 | 154428309046000 | 981698000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
2395 | 32 | 32 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154550090050000 | 154550289078000 | 199028000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
2395 | 34 | 34 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154554475037000 | 154555054426000 | 579389000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
2395 | 36 | 36 | transaction | COMMITTED | 421490957953640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154557795924000 | 154557961635000 | 165711000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
35 | 1 | 1 | transaction | COMMITTED | 421490957952768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1593949116000 | 1594292776000 | 343660000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2397 | 6 | 6 | transaction | COMMITTED | 421490957954512 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154504597547000 | 154504639063000 | 41516000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2397 | 12 | 12 | transaction | COMMITTED | 421490957954512 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154507951531000 | 154508101140000 | 149609000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
2397 | 15 | 15 | transaction | COMMITTED | 421490957954512 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154509047408000 | 154509664556000 | 617148000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
2397 | 19 | 19 | transaction | COMMITTED | 421490957954512 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 154511082706000 | 154511228066000 | 145360000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT |
|