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 | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1796922396000 | 1796947788000 | 25392000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1797162643000 | 1797187754000 | 25111000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1798207710000 | 1798223514000 | 15804000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1798431667000 | 1798445655000 | 13988000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1749229129000 | 1750844363000 | 1615234000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1776222471000 | 1776251207000 | 28736000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1776526691000 | 1776633338000 | 106647000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1776768604000 | 1778804325000 | 2035721000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1787644240000 | 1787757619000 | 113379000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1795286319000 | 1795314453000 | 28134000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421815281776384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1582059116000 | 1582383615000 | 324499000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
3425 | 6 | 6 | transaction | COMMITTED | 421815281777256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 634154915825000 | 634154961811000 | 45986000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|