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 | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1777279827000 | 1777297697000 | 17870000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1777455873000 | 1777473304000 | 17431000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1778282105000 | 1778293912000 | 11807000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1778455870000 | 1778466009000 | 10139000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1731719479000 | 1733292226000 | 1572747000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1761201084000 | 1761216440000 | 15356000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1761457307000 | 1761540675000 | 83368000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1761656469000 | 1763765264000 | 2108795000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1770852011000 | 1770916982000 | 64971000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1775968192000 | 1775989769000 | 21577000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421288747894528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1564360930000 | 1564697886000 | 336956000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
4169 | 6 | 6 | transaction | COMMITTED | 421288747895400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 317591842203000 | 317591906536000 | 64333000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|