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 | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1742358976000 | 1742387081000 | 28105000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1742526256000 | 1742541154000 | 14898000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1743218537000 | 1743230043000 | 11506000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1743410345000 | 1743421518000 | 11173000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1698257671000 | 1699972762000 | 1715091000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1727139658000 | 1727175052000 | 35394000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1727456861000 | 1727555102000 | 98241000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1727677312000 | 1730323948000 | 2646636000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1736645324000 | 1736687383000 | 42059000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421346701736552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1741273231000 | 1741291379000 | 18148000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421346701735680 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1528722024000 | 1529033025000 | 311001000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
7571 | 36 | 36 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451251227702000 | 451251427820000 | 200118000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
7571 | 12 | 12 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451001908616000 | 451002043444000 | 134828000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
7571 | 15 | 15 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451002841216000 | 451003278973000 | 437757000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
7571 | 19 | 19 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451004482147000 | 451004591586000 | 109439000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
7571 | 21 | 21 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451005217810000 | 451005909773000 | 691963000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
7571 | 23 | 23 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451006652244000 | 451007084580000 | 432336000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
7571 | 26 | 26 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451014890600000 | 451015704635000 | 814035000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
7571 | 30 | 30 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451216757794000 | 451216981629000 | 223835000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
7571 | 32 | 32 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451233640940000 | 451236400954000 | 2760014000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
7571 | 34 | 34 | transaction | COMMITTED | 421346701739168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451245113505000 | 451245332737000 | 219232000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
7573 | 33 | 33 | transaction | COMMITTED | 421346701737424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451218726855000 | 451219708353000 | 981498000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
7573 | 11 | 11 | transaction | COMMITTED | 421346701737424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451193371045000 | 451193567712000 | 196667000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
7573 | 15 | 15 | transaction | COMMITTED | 421346701737424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451194626722000 | 451194904601000 | 277879000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
7573 | 17 | 17 | transaction | COMMITTED | 421346701737424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451195635184000 | 451196569620000 | 934436000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT |
|