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 | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1464181196000 | 1464195713000 | 14517000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1464318281000 | 1464329660000 | 11379000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1465011600000 | 1465018712000 | 7112000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1465116134000 | 1465122238000 | 6104000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1449345469000 | 1449903200000 | 557731000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1457536340000 | 1457543418000 | 7078000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1457645853000 | 1457687222000 | 41369000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1457747246000 | 1458814963000 | 1067717000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1461242468000 | 1461267864000 | 25396000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1463547987000 | 1463560891000 | 12904000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421100184106752 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1328447584000 | 1328765245000 | 317661000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
10839 | 6 | 6 | transaction | COMMITTED | 421100184107624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 755458439772000 | 755458488498000 | 48726000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|