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 | 421623332084328 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1461976723000 | 1461982784000 | 6061000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421623332083456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1329026332000 | 1329322630000 | 296298000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
207 | 0 | 27 | transaction | COMMITTED | 421623332086944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 19954980474000 | 19955372642000 | 392168000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
421 | 34 | NULL | transaction | ACTIVE | 421623332085200 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 30990222164000 | 30993377886000 | 3155722000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
209 | 0 | 46 | transaction | COMMITTED | 421623332084328 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 19995254854000 | 19995571988000 | 317134000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 45 | STATEMENT | |
423 | 24 | 24 | transaction | COMMITTED | 421623332086072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 30950249678000 | 30950771151000 | 521473000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
211 | 0 | 46 | transaction | COMMITTED | 421623332085200 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 19967699125000 | 19967980843000 | 281718000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 45 | STATEMENT | |
425 | 6 | 6 | transaction | COMMITTED | 421623332084328 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 30988358582000 | 30988419713000 | 61131000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|