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 | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1556825161000 | 1556838666000 | 13505000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1556959775000 | 1556972827000 | 13052000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1557545992000 | 1557555346000 | 9354000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1557670757000 | 1557679415000 | 8658000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1538424251000 | 1539179753000 | 755502000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1547921614000 | 1547930550000 | 8936000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1548050009000 | 1548088377000 | 38368000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1548145699000 | 1549288137000 | 1142438000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1552724368000 | 1552753689000 | 29321000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1555832820000 | 1555846323000 | 13503000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421670102923008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1383713928000 | 1383986028000 | 272100000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1227 | 6 | 6 | transaction | COMMITTED | 421670102923880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 195585671254000 | 195585710460000 | 39206000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|