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 | 421586717764200 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1735059207000 | 1735075639000 | 16432000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421586717763328 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1506506466000 | 1506899341000 | 392875000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
15243 | 255 | NULL | transaction | ACTIVE | 421586717772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 595245654390000 | 595245887178000 | 232788000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 254 | STATEMENT | |
15244 | 3 | 3 | transaction | COMMITTED | 421586717764200 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 595030708273000 | 595031013328000 | 305055000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
14175 | 0 | 49 | transaction | COMMITTED | 421586717771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 554679512662000 | 554679559863000 | 47201000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
15246 | 30 | 30 | transaction | COMMITTED | 421586717770304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 595222759146000 | 595223143530000 | 384384000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
14391 | 0 | 49 | transaction | COMMITTED | 421586717769432 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 563445622318000 | 563445678926000 | 56608000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
15248 | 31 | 31 | transaction | COMMITTED | 421586717765072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 595223840718000 | 595224758944000 | 918226000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 30 | STATEMENT | |
14179 | 0 | 3 | transaction | COMMITTED | 421586717765072 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 554553392862000 | 554553700052000 | 307190000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
15250 | 6 | 6 | transaction | COMMITTED | 421586717765944 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 595243735906000 | 595243758243000 | 22337000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|