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 | |
1461 | 6 | 6 | transaction | COMMITTED | 421288747898888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 118381643066000 | 118381676880000 | 33814000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
1465 | 4658 | 4658 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119145420067000 | 119145524146000 | 104079000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4657 | STATEMENT | |
1465 | 4660 | 4660 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119145756628000 | 119145844133000 | 87505000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4659 | STATEMENT | |
1465 | 4662 | 4662 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119146061743000 | 119146149266000 | 87523000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4661 | STATEMENT | |
1465 | 4664 | 4664 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119146403979000 | 119146488865000 | 84886000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4663 | STATEMENT | |
1465 | 4666 | 4666 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119146774827000 | 119146860426000 | 85599000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4665 | STATEMENT | |
1465 | 4648 | 4648 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119143908276000 | 119144010314000 | 102038000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4647 | STATEMENT | |
1465 | 4650 | 4650 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119144231409000 | 119144319944000 | 88535000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4649 | STATEMENT | |
1465 | 4652 | 4652 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119144536237000 | 119144623289000 | 87052000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4651 | STATEMENT | |
1465 | 4654 | 4654 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119144832260000 | 119144919235000 | 86975000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4653 | STATEMENT | |
1465 | 4656 | 4656 | transaction | COMMITTED | 421288747897144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119145138208000 | 119145225526000 | 87318000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4655 | STATEMENT | |
1473 | 35 | 35 | transaction | COMMITTED | 421288747899760 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 119121904002000 | 119122126355000 | 222353000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 34 | STATEMENT | |
1473 | 12 | 12 | transaction | COMMITTED | 421288747899760 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 118956018689000 | 118956173322000 | 154633000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
1473 | 15 | 15 | transaction | COMMITTED | 421288747899760 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 118957089188000 | 118957609391000 | 520203000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT |
|