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 | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1642790541000 | 1642797896000 | 7355000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1642868038000 | 1642880281000 | 12243000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1643241419000 | 1643247612000 | 6193000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1643355653000 | 1643361614000 | 5961000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1626573678000 | 1627415312000 | 841634000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1635253597000 | 1635259737000 | 6140000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1635327227000 | 1635351717000 | 24490000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1635382916000 | 1636755551000 | 1372635000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1639562632000 | 1639583158000 | 20526000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1642108052000 | 1642117428000 | 9376000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421302637717248 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490428622000 | 1490806041000 | 377419000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
10307 | 6 | 6 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 613690748659000 | 613690794221000 | 45562000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
10307 | 12 | 12 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 613693904145000 | 613694041523000 | 137378000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
10307 | 15 | 15 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 613695043948000 | 613695614963000 | 571015000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
10307 | 19 | 19 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 613697200717000 | 613697319359000 | 118642000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
10307 | 21 | 21 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 613697898134000 | 613698372565000 | 474431000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
10307 | 23 | 23 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 613699002489000 | 613699243944000 | 241455000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
10307 | 26 | 26 | transaction | COMMITTED | 421302637718120 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 613706125661000 | 613706900476000 | 774815000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
10309 | 6 | 6 | transaction | COMMITTED | 421302637718992 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 613835147955000 | 613835192242000 | 44287000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|