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 | 421858193177192 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1477729724000 | 1477739574000 | 9850000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421858193176320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1339979185000 | 1340276633000 | 297448000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
6526 | 0 | 49 | transaction | COMMITTED | 421858193181552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 280281925166000 | 280281971151000 | 45985000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
7383 | 40 | 40 | transaction | COMMITTED | 421858193178064 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 315299583352000 | 315300016089000 | 432737000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 39 | STATEMENT | |
6744 | 0 | 38 | transaction | COMMITTED | 421858193178064 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289523402383000 | 289523824795000 | 422412000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
7387 | 30 | 30 | transaction | COMMITTED | 421858193180680 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 315359198761000 | 315359485470000 | 286709000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
7174 | 0 | 38 | transaction | COMMITTED | 421858193180680 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 306801807076000 | 306802090183000 | 283107000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
7389 | 6 | 6 | transaction | COMMITTED | 421858193178936 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 315354714136000 | 315354773926000 | 59790000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
7390 | 6 | 6 | transaction | COMMITTED | 421858193181552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 315362250045000 | 315362304468000 | 54423000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
7391 | 3 | 3 | transaction | COMMITTED | 421858193177192 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 315334460898000 | 315334987668000 | 526770000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT |
|