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 | 421207458089576 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1848509890000 | 1848516110000 | 6220000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421207458088704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1657389387000 | 1657681594000 | 292207000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
7588 | 0 | 38 | transaction | COMMITTED | 421207458092192 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 708281639539000 | 708282035528000 | 395989000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
7803 | 32 | NULL | transaction | ACTIVE | 421207458090448 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 721335091471000 | 721335848947000 | 757476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
5236 | 0 | 47 | transaction | COMMITTED | 421207458092192 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 551044993597000 | 551045033972000 | 40375000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
7805 | 26 | 26 | transaction | COMMITTED | 421207458091320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 721236811728000 | 721237579046000 | 767318000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
5880 | 0 | 22 | transaction | COMMITTED | 421207458089576 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 594333531869000 | 594333788678000 | 256809000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 21 | STATEMENT | |
7807 | 6 | 6 | transaction | COMMITTED | 421207458089576 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 721328337740000 | 721328372377000 | 34637000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|