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 | 422194420562536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2559023856000 | 2559031064000 | 7208000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422194420561664 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2298456047000 | 2299013888000 | 557841000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
6265 | 0 | 49 | transaction | COMMITTED | 422194420564280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 392850225695000 | 392850266346000 | 40651000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
7551 | 38 | 38 | transaction | COMMITTED | 422194420563408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 470145068078000 | 470145493165000 | 425087000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
7555 | 33 | 33 | transaction | COMMITTED | 422194420564280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 470157084720000 | 470157822225000 | 737505000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
7556 | 3 | 3 | transaction | COMMITTED | 422194420562536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 470104655802000 | 470105116933000 | 461131000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
5631 | 0 | 31 | transaction | COMMITTED | 422194420565152 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 355331550054000 | 355331939676000 | 389622000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 30 | STATEMENT | |
7558 | 6 | 6 | transaction | COMMITTED | 422194420566024 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 470172896174000 | 470172945181000 | 49007000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
6489 | 0 | 47 | transaction | COMMITTED | 422194420564280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 406949861900000 | 406949916908000 | 55008000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 46 | STATEMENT | |
7560 | 19 | NULL | transaction | ACTIVE | 422194420565152 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 470174944975000 | 470174999181000 | 54206000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT |
|