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 | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1784042254000 | 1784050770000 | 8516000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1784133218000 | 1784142561000 | 9343000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1784574632000 | 1784582250000 | 7618000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1784703324000 | 1784710464000 | 7140000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1759929890000 | 1761089590000 | 1159700000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1774507338000 | 1774520850000 | 13512000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1774670960000 | 1774731823000 | 60863000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1774837631000 | 1775777343000 | 939712000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1779435429000 | 1779462415000 | 26986000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1783291952000 | 1783304958000 | 13006000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421174186006272 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1603319412000 | 1603712737000 | 393325000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
13365 | 6 | 6 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 762239501640000 | 762239554071000 | 52431000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
13365 | 12 | 12 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 762250436560000 | 762250621173000 | 184613000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
13365 | 15 | 15 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 762251576111000 | 762251984323000 | 408212000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
13365 | 19 | 19 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 762253556231000 | 762253685880000 | 129649000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
13365 | 21 | 21 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 762254297355000 | 762255022201000 | 724846000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
13365 | 23 | 23 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 762255712248000 | 762256017311000 | 305063000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
13365 | 26 | 26 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 762262782823000 | 762264100477000 | 1317654000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
13367 | 6 | 6 | transaction | COMMITTED | 421174186007144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 762368868567000 | 762368914126000 | 45559000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|