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 | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1653963277000 | 1653977809000 | 14532000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1654114972000 | 1654128786000 | 13814000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1654901281000 | 1654913136000 | 11855000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1655079127000 | 1655089096000 | 9969000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1613693772000 | 1615087507000 | 1393735000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1638071585000 | 1638087733000 | 16148000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1638330810000 | 1638470286000 | 139476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1638610283000 | 1641181260000 | 2570977000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1647815180000 | 1647881332000 | 66152000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1652849376000 | 1652881361000 | 31985000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421201288115968 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1456561874000 | 1456835675000 | 273801000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
8879 | 6 | 6 | transaction | COMMITTED | 421201288118584 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540141084666000 | 540141138441000 | 53775000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
8879 | 12 | 12 | transaction | COMMITTED | 421201288118584 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540153795741000 | 540153988264000 | 192523000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
8879 | 15 | 15 | transaction | COMMITTED | 421201288118584 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540154897136000 | 540155725903000 | 828767000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
8879 | 19 | 19 | transaction | COMMITTED | 421201288118584 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540157097182000 | 540157232604000 | 135422000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
8879 | 21 | 21 | transaction | COMMITTED | 421201288118584 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540157796599000 | 540158546980000 | 750381000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
8879 | 23 | 23 | transaction | COMMITTED | 421201288118584 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540159197594000 | 540159498169000 | 300575000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
8879 | 26 | 26 | transaction | COMMITTED | 421201288118584 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540166058753000 | 540167285523000 | 1226770000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
8881 | 6 | 6 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 540254777269000 | 540254822274000 | 45005000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|