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 | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1886912956000 | 1886932062000 | 19106000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1887098897000 | 1887117332000 | 18435000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1888029381000 | 1888045817000 | 16436000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1888250823000 | 1888264320000 | 13497000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1841999187000 | 1843493340000 | 1494153000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1867870642000 | 1867910655000 | 40013000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1868265156000 | 1868358765000 | 93609000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1868506632000 | 1870639654000 | 2133022000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1879422323000 | 1879507292000 | 84969000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1885466111000 | 1885491124000 | 25013000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421578103465728 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1688586526000 | 1688958456000 | 371930000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
5797 | 6 | 6 | transaction | COMMITTED | 421578103466600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 404583734765000 | 404583787650000 | 52885000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|