SELECT * FROM `events_transactions_current`
|
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 | 14 | 14 | transaction | COMMITTED | 421673441475176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1576959047000 | 1576967352000 | 8305000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421673441474304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1388252412000 | 1388462191000 | 209779000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1824 | 0 | 47 | transaction | COMMITTED | 421673441476048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 175411683530000 | 175411729369000 | 45839000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
2895 | 38 | 38 | transaction | COMMITTED | 421673441475176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 254464933887000 | 254465159218000 | 225331000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
542 | 0 | 20 | transaction | COMMITTED | 421673441475176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 58487680712000 | 58488233574000 | 552862000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 19 | STATEMENT | |
2897 | 6 | 6 | transaction | COMMITTED | 421673441476048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 254470535980000 | 254470575998000 | 40018000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|