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 | 421731173608040 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1973210870000 | 1973218023000 | 7153000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421731173607168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1787698057000 | 1788017134000 | 319077000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
4282 | 0 | 49 | transaction | COMMITTED | 421731173608912 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 254700683432000 | 254700727996000 | 44564000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
4497 | 1889 | NULL | transaction | ACTIVE | 421731173608040 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 265854913613000 | 265855003774000 | 90161000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 1888 | STATEMENT | |
3218 | 0 | 47 | transaction | COMMITTED | 421731173609784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 192686492408000 | 192686528344000 | 35936000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
4503 | 36 | 36 | transaction | COMMITTED | 421731173610656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 265851056956000 | 265851230098000 | 173142000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
4076 | 0 | 47 | transaction | COMMITTED | 421731173609784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 243602359862000 | 243602388349000 | 28487000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
4505 | 33 | 33 | transaction | COMMITTED | 421731173609784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 265762663125000 | 265763251357000 | 588232000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
869 | 0 | 47 | transaction | COMMITTED | 421731173609784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 55876156298000 | 55876196870000 | 40572000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
4507 | 6 | 6 | transaction | COMMITTED | 421731173608912 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 265846115509000 | 265846138424000 | 22915000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|