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 | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1722830386000 | 1722840180000 | 9794000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1722937286000 | 1722952231000 | 14945000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1723477532000 | 1723486384000 | 8852000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1723609939000 | 1723617836000 | 7897000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1705420575000 | 1707048634000 | 1628059000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1715304226000 | 1715325317000 | 21091000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1715429868000 | 1715465039000 | 35171000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1715519370000 | 1715971002000 | 451632000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1719201113000 | 1719236544000 | 35431000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1722021112000 | 1722038678000 | 17566000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421619309389568 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1557557583000 | 1557990832000 | 433249000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
12317 | 6 | 6 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540240767617000 | 540240818504000 | 50887000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
12317 | 12 | 12 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540244425316000 | 540244580984000 | 155668000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
12317 | 15 | 15 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540245736286000 | 540246309533000 | 573247000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
12317 | 19 | 19 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540247925419000 | 540248078106000 | 152687000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
12317 | 21 | 21 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540248672877000 | 540249245876000 | 572999000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
12317 | 23 | 23 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540249878583000 | 540250137331000 | 258748000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
12317 | 26 | 26 | transaction | COMMITTED | 421619309390440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540264248001000 | 540265238518000 | 990517000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
12319 | 6 | 6 | transaction | COMMITTED | 421619309392184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540269933828000 | 540269973700000 | 39872000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
12321 | 3 | 3 | transaction | COMMITTED | 421619309391312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540264062418000 | 540264569598000 | 507180000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT |
|