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 | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1534458909000 | 1534467986000 | 9077000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1534547543000 | 1534556020000 | 8477000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1534975528000 | 1534982412000 | 6884000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1535077958000 | 1535083887000 | 5929000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1519458387000 | 1520158737000 | 700350000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1527864696000 | 1527871666000 | 6970000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1527951903000 | 1528000789000 | 48886000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1528035634000 | 1528783110000 | 747476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1531256592000 | 1531281495000 | 24903000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1533773405000 | 1533786753000 | 13348000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421448485766912 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1390471231000 | 1390725198000 | 253967000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
10144 | 32 | 32 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664831998869000 | 664833175094000 | 1176225000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
10144 | 11 | 11 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664778476533000 | 664778645809000 | 169276000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
10144 | 15 | 15 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664780114441000 | 664780269031000 | 154590000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
10144 | 17 | 17 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664781101902000 | 664781925073000 | 823171000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
10144 | 19 | 19 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664789051376000 | 664789491841000 | 440465000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
10144 | 21 | 21 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664790537487000 | 664790759259000 | 221772000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
10144 | 24 | 24 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664819248585000 | 664819710663000 | 462078000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
10144 | 26 | 26 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664820628203000 | 664820807807000 | 179604000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
10144 | 28 | 28 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664826488052000 | 664826668938000 | 180886000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 27 | STATEMENT | |
10144 | 30 | 30 | transaction | COMMITTED | 421448485770400 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664830611121000 | 664831157560000 | 546439000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
10145 | 32 | 32 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664793661398000 | 664794724724000 | 1063326000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
10145 | 11 | 11 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664768487287000 | 664768686187000 | 198900000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
10145 | 15 | 15 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664770149565000 | 664770324672000 | 175107000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
10145 | 17 | 17 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 664771055568000 | 664771640222000 | 584654000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT |
|