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 | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1451815219000 | 1451823217000 | 7998000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1451896001000 | 1451904463000 | 8462000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1452311073000 | 1452317797000 | 6724000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1452416020000 | 1452422142000 | 6122000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1436226650000 | 1436967659000 | 741009000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1444902827000 | 1444909332000 | 6505000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1445004104000 | 1445031245000 | 27141000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1445063558000 | 1446287811000 | 1224253000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1448835536000 | 1448862139000 | 26603000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1451150946000 | 1451164988000 | 14042000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421907026650880 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1308545564000 | 1308770282000 | 224718000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
4893 | 6 | 6 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 452221153425000 | 452221195104000 | 41679000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
4893 | 12 | 12 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 452224267367000 | 452224407339000 | 139972000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
4893 | 15 | 15 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 452225379871000 | 452225799023000 | 419152000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
4893 | 19 | 19 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 452227104249000 | 452227241051000 | 136802000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
4893 | 21 | 21 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 452227750532000 | 452228221680000 | 471148000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
4893 | 23 | 23 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 452228786292000 | 452229012594000 | 226302000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
4893 | 26 | 26 | transaction | COMMITTED | 421907026651752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 452235550003000 | 452236304332000 | 754329000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
4895 | 6 | 6 | transaction | COMMITTED | 421907026652624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 452336074159000 | 452336125460000 | 51301000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|