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 | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1863054390000 | 1863067272000 | 12882000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1863202715000 | 1863215774000 | 13059000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1863824822000 | 1863833946000 | 9124000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1863955372000 | 1863963033000 | 7661000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1828085511000 | 1829699183000 | 1613672000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1850976682000 | 1850993280000 | 16598000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1851157966000 | 1851215557000 | 57591000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1851288489000 | 1853141056000 | 1852567000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1858308449000 | 1858352955000 | 44506000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1862031944000 | 1862053575000 | 21631000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421872093165312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1652123107000 | 1652358360000 | 235253000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
13817 | 36 | 36 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807872987750000 | 807873129953000 | 142203000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
13817 | 12 | 12 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807693157230000 | 807693293533000 | 136303000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
13817 | 15 | 15 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807694288653000 | 807694931129000 | 642476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
13817 | 19 | 19 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807701201707000 | 807702348132000 | 1146425000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
13817 | 21 | 21 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807703683275000 | 807704598303000 | 915028000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
13817 | 23 | 23 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807708422219000 | 807708837292000 | 415073000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
13817 | 26 | 26 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807716132490000 | 807717509170000 | 1376680000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
13817 | 30 | 30 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807859199133000 | 807859525203000 | 326070000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
13817 | 32 | 32 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807868197057000 | 807868595208000 | 398151000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
13817 | 34 | 34 | transaction | COMMITTED | 421872093167928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807871516686000 | 807871673294000 | 156608000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
13823 | 6 | 6 | transaction | COMMITTED | 421872093166184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 807880116046000 | 807880156841000 | 40795000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|