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 | 421571314035304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1530215438000 | 1530221096000 | 5658000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421571314034432 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1382448566000 | 1382780790000 | 332224000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
6036 | 0 | 38 | transaction | COMMITTED | 421571314035304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 360794465452000 | 360794870370000 | 404918000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
7535 | 32 | NULL | transaction | ACTIVE | 421571314036176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 434737883670000 | 434738206926000 | 323256000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
5610 | 0 | 38 | transaction | COMMITTED | 421571314035304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 337602089600000 | 337602362027000 | 272427000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
7537 | 26 | 26 | transaction | COMMITTED | 421571314035304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 434596116867000 | 434597311868000 | 1195001000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
7538 | 36 | 36 | transaction | COMMITTED | 421571314037920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 434641265525000 | 434641499116000 | 233591000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
7539 | 3 | 3 | transaction | COMMITTED | 421571314037048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 434578511060000 | 434578988039000 | 476979000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
7112 | 0 | 47 | transaction | COMMITTED | 421571314037048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 413397295788000 | 413397351457000 | 55669000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
7541 | 6 | 6 | transaction | COMMITTED | 421571314038792 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 434726241128000 | 434726299515000 | 58387000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|