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 | |
2061 | 6 | 6 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148280729679000 | 148280770858000 | 41179000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2061 | 12 | 12 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148283827411000 | 148283958863000 | 131452000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
2061 | 15 | 15 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148284862591000 | 148285451860000 | 589269000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
2061 | 19 | 19 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148286931949000 | 148287028877000 | 96928000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
2061 | 21 | 21 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148287578706000 | 148288063159000 | 484453000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
2061 | 23 | 23 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148288834522000 | 148289179693000 | 345171000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
2061 | 26 | 26 | transaction | COMMITTED | 421152119982696 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148296140541000 | 148296895517000 | 754976000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
2063 | 6 | 6 | transaction | COMMITTED | 421152119983568 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 148384717579000 | 148384759267000 | 41688000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|