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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1537 | 6 | 6 | transaction | COMMITTED | 421174186011504 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120268846015000 | 120268891909000 | 45894000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
1537 | 12 | 12 | transaction | COMMITTED | 421174186011504 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120569357017000 | 120569566677000 | 209660000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
1537 | 15 | 15 | transaction | COMMITTED | 421174186011504 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120570523669000 | 120571147684000 | 624015000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
1537 | 19 | 19 | transaction | COMMITTED | 421174186011504 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120572278467000 | 120572389427000 | 110960000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
1537 | 21 | 21 | transaction | COMMITTED | 421174186011504 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120573035478000 | 120574022705000 | 987227000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
1537 | 23 | 23 | transaction | COMMITTED | 421174186011504 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120574904761000 | 120575346115000 | 441354000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
1537 | 26 | 26 | transaction | COMMITTED | 421174186011504 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120590529534000 | 120591791642000 | 1262108000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
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 | |
1540 | 33 | 33 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120552100145000 | 120552257560000 | 157415000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
1540 | 35 | 35 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120552843927000 | 120553215000000 | 371073000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 34 | STATEMENT | |
1540 | 37 | 37 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120553739011000 | 120553899324000 | 160313000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 36 | STATEMENT | |
1540 | 17 | 17 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120537973044000 | 120538271789000 | 298745000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
1540 | 19 | 19 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120538754635000 | 120538898510000 | 143875000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
1540 | 21 | 21 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120543628177000 | 120543896425000 | 268248000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
1540 | 24 | 24 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120545426886000 | 120545606434000 | 179548000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
1540 | 27 | 27 | transaction | COMMITTED | 421174186008888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 120549572727000 | 120549793294000 | 220567000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT |
|