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 | 421766018968168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1494174621000 | 1494181137000 | 6516000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421766018967296 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1356364121000 | 1356714205000 | 350084000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
15590 | 0 | 47 | transaction | COMMITTED | 421766018972528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 716645298985000 | 716645319400000 | 20415000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
17945 | 44 | 44 | transaction | COMMITTED | 421766018970784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 812170802140000 | 812171106819000 | 304679000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 43 | STATEMENT | |
16448 | 0 | 324 | transaction | COMMITTED | 421766018969912 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 754484849116000 | 754485070384000 | 221268000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 323 | STATEMENT | |
17947 | 33 | 33 | transaction | COMMITTED | 421766018969912 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 812049086174000 | 812050018160000 | 931986000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
17520 | 0 | 9 | transaction | COMMITTED | 421766018968168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 796385504541000 | 796385904693000 | 400152000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT | |
17949 | 33 | 33 | transaction | COMMITTED | 421766018968168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 812093114973000 | 812093761631000 | 646658000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
17308 | 0 | 38 | transaction | COMMITTED | 421766018969040 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 787937652173000 | 787938040276000 | 388103000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
17951 | 15 | NULL | transaction | ACTIVE | 421766018969040 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 812181912980000 | 812182133701000 | 220721000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
17524 | 0 | 47 | transaction | COMMITTED | 421766018970784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 796864534767000 | 796864590265000 | 55498000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
17953 | 6 | 6 | transaction | COMMITTED | 421766018971656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 812172841739000 | 812172881053000 | 39314000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|