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 | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1435567180000 | 1435575182000 | 8002000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1435644080000 | 1435655444000 | 11364000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1436072414000 | 1436079338000 | 6924000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1436177318000 | 1436183022000 | 5704000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1420416245000 | 1421146644000 | 730399000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1428514733000 | 1428521318000 | 6585000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1428595670000 | 1428622290000 | 26620000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1428661630000 | 1429378514000 | 716884000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1432212382000 | 1432238282000 | 25900000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1434859771000 | 1434873365000 | 13594000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421152119981824 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1300211463000 | 1300476477000 | 265014000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2075 | 6 | 6 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 149310275662000 | 149310327607000 | 51945000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2075 | 12 | 12 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 149314300432000 | 149314457264000 | 156832000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
2075 | 15 | 15 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 149315513696000 | 149316216110000 | 702414000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
2075 | 19 | 19 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 149317946634000 | 149318069866000 | 123232000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
2075 | 21 | 21 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 149318616597000 | 149319138682000 | 522085000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
2075 | 23 | 23 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 149319787048000 | 149320051272000 | 264224000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
2075 | 26 | 26 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 149326928930000 | 149327667138000 | 738208000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
2079 | 6 | 6 | transaction | COMMITTED | 421152119983568 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 149395980757000 | 149396039504000 | 58747000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|