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 | 421306700515944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1637946046000 | 1637951818000 | 5772000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421306700515072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490044253000 | 1490287985000 | 243732000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
9646 | 0 | 49 | transaction | COMMITTED | 421306700520304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 613412352130000 | 613412394221000 | 42091000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
10289 | 36 | 36 | transaction | COMMITTED | 421306700517688 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 659491161068000 | 659491342463000 | 181395000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
9862 | 0 | 38 | transaction | COMMITTED | 421306700516816 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 630393697946000 | 630393966236000 | 268290000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
10291 | 43 | 43 | transaction | COMMITTED | 421306700518560 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 659505272489000 | 659505629389000 | 356900000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 42 | STATEMENT | |
9436 | 0 | 47 | transaction | COMMITTED | 421306700516816 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 600450416613000 | 600450479201000 | 62588000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
10293 | 15 | 15 | transaction | COMMITTED | 421306700519432 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 659509433286000 | 659509635975000 | 202689000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
10294 | 6 | 6 | transaction | COMMITTED | 421306700516816 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 659499315510000 | 659499360596000 | 45086000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
10295 | 3 | 3 | transaction | COMMITTED | 421306700515944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 659463310923000 | 659463836157000 | 525234000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT |
|