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 | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1755389279000 | 1755403602000 | 14323000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1755538679000 | 1755553322000 | 14643000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1756208204000 | 1756218319000 | 10115000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1756363688000 | 1756377603000 | 13915000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1720649934000 | 1721995870000 | 1345936000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1743208534000 | 1743234052000 | 25518000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1743420177000 | 1743493817000 | 73640000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1743580616000 | 1745006247000 | 1425631000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1750419159000 | 1750458881000 | 39722000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1754230913000 | 1754248455000 | 17542000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421855700653824 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1554095505000 | 1554464835000 | 369330000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1853 | 33 | 33 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92463081043000 | 92463722090000 | 641047000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
1853 | 11 | 11 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92447358737000 | 92447444470000 | 85733000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
1853 | 15 | 15 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92448790702000 | 92448924551000 | 133849000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
1853 | 17 | 17 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92449587243000 | 92450025835000 | 438592000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
1853 | 19 | 19 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92450711380000 | 92450950018000 | 238638000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
1853 | 21 | 21 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92451606337000 | 92451704419000 | 98082000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
1853 | 25 | 25 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92460064422000 | 92460178100000 | 113678000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 24 | STATEMENT | |
1853 | 27 | 27 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92460672495000 | 92460787543000 | 115048000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
1853 | 29 | 29 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92461263074000 | 92461360332000 | 97258000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 28 | STATEMENT | |
1853 | 31 | 31 | transaction | COMMITTED | 421855700654696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92462029672000 | 92462390832000 | 361160000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 30 | STATEMENT | |
1855 | 6 | 6 | transaction | COMMITTED | 421855700655568 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 92486962290000 | 92487005386000 | 43096000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|