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 | |
3161 | 6 | 6 | transaction | COMMITTED | 421302569631184 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 529190425835000 | 529190469367000 | 43532000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
3163 | 8 | 8 | transaction | COMMITTED | 421302569630312 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 529174417048000 | 529174690883000 | 273835000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7 | STATEMENT |
|