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 | 421826398186088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1547376522000 | 1547382183000 | 5661000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421826398185216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1391752361000 | 1391978256000 | 225895000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
873 | 0 | 43 | transaction | COMMITTED | 421826398186088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 53964091075000 | 53964170321000 | 79246000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 42 | STATEMENT | |
1515 | 42 | 42 | transaction | COMMITTED | 421826398186088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 95433699308000 | 95434004208000 | 304900000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 41 | STATEMENT | |
1302 | 0 | 92 | transaction | COMMITTED | 421826398186960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 80803013252000 | 80803757644000 | 744392000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 91 | STATEMENT | |
1517 | 11 | 11 | transaction | COMMITTED | 421826398187832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 95427418382000 | 95428363199000 | 944817000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
664 | 0 | 38 | transaction | COMMITTED | 421826398186960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 36836131386000 | 36836175957000 | 44571000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
1519 | 20 | 20 | transaction | COMMITTED | 421826398186960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 95429895156000 | 95429996588000 | 101432000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 19 | STATEMENT | |
879 | 0 | 38 | transaction | COMMITTED | 421826398186088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 54345686254000 | 54345986696000 | 300442000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
1521 | 6 | 6 | transaction | COMMITTED | 421826398188704 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 95430747919000 | 95430786234000 | 38315000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|