SELECT * FROM `events_transactions_history`
|
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 | 11 | 11 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1491541220000 | 1491550953000 | 9733000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1491645390000 | 1491657526000 | 12136000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1492231758000 | 1492241280000 | 9522000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1492366599000 | 1492375249000 | 8650000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1473760947000 | 1474483774000 | 722827000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1482969154000 | 1482991564000 | 22410000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1483111541000 | 1483150754000 | 39213000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1483215344000 | 1484522326000 | 1306982000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1487932769000 | 1487971105000 | 38336000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490687754000 | 1490704865000 | 17111000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421302569629440 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1350105494000 | 1350387106000 | 281612000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2233 | 8 | 8 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 374439211599000 | 374439243966000 | 32367000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7 | STATEMENT | |
2233 | 11 | 11 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 374439870386000 | 374440139928000 | 269542000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
2233 | 13 | 13 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 374440443808000 | 374440572806000 | 128998000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 12 | STATEMENT | |
2233 | 15 | 15 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 374441106507000 | 374441313181000 | 206674000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
2233 | 20 | 20 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 374450955671000 | 374451413892000 | 458221000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 19 | STATEMENT | |
2233 | 22 | 22 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 374483836689000 | 374484539658000 | 702969000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 21 | STATEMENT | |
2233 | 24 | 24 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 374487526927000 | 374487747602000 | 220675000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
2233 | 26 | 26 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 374489400577000 | 374489694396000 | 293819000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
2235 | 6 | 6 | transaction | COMMITTED | 421302569631184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 374505682072000 | 374505724266000 | 42194000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|