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 | 422029597502056 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1729384666000 | 1729393661000 | 8995000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422029597501184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1517215621000 | 1517460512000 | 244891000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
12242 | 32 | 32 | transaction | COMMITTED | 422029597502928 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 683488941967000 | 683490006527000 | 1064560000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
12243 | 3 | 3 | transaction | COMMITTED | 422029597502056 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 683394331255000 | 683395406594000 | 1075339000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
9462 | 0 | 49 | transaction | COMMITTED | 422029597504672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 539213425688000 | 539213465124000 | 39436000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
12245 | 43 | NULL | transaction | ACTIVE | 422029597503800 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 683493768209000 | 683494209813000 | 441604000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 42 | STATEMENT | |
11604 | 0 | 40 | transaction | COMMITTED | 422029597503800 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 652573108629000 | 652573422448000 | 313819000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 39 | STATEMENT | |
12247 | 6 | 6 | transaction | COMMITTED | 422029597504672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 683492121494000 | 683492147303000 | 25809000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|