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 | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1747837669000 | 1747850779000 | 13110000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1747965529000 | 1747978020000 | 12491000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1748643941000 | 1748654290000 | 10349000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1748822133000 | 1748832797000 | 10664000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1708273329000 | 1709867561000 | 1594232000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1735869210000 | 1735881176000 | 11966000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1736100250000 | 1736168281000 | 68031000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1736287499000 | 1737682459000 | 1394960000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1742689747000 | 1742734545000 | 44798000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1746714631000 | 1746737277000 | 22646000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422113212888832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1550669811000 | 1551081281000 | 411470000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
5283 | 6 | 6 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 262434188400000 | 262434232807000 | 44407000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
5283 | 11 | 11 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 262436225216000 | 262436313568000 | 88352000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
5283 | 15 | 15 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 262437411937000 | 262437542998000 | 131061000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
5283 | 17 | 17 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 262438027699000 | 262438426155000 | 398456000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
5283 | 19 | 19 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 262438918019000 | 262439127686000 | 209667000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
5283 | 21 | 21 | transaction | COMMITTED | 422113212889704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 262439766118000 | 262439861690000 | 95572000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
5285 | 6 | 6 | transaction | COMMITTED | 422113212890576 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 262440423644000 | 262440450260000 | 26616000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|