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 | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1459663915000 | 1459671210000 | 7295000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1459749990000 | 1459758562000 | 8572000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1460150634000 | 1460157366000 | 6732000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1460252924000 | 1460258518000 | 5594000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1445091755000 | 1445790523000 | 698768000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1453122755000 | 1453130375000 | 7620000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1453206046000 | 1453234198000 | 28152000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1453267022000 | 1453991422000 | 724400000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1456551363000 | 1456572105000 | 20742000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1458972287000 | 1458982262000 | 9975000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421734165911296 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1308304433000 | 1308529661000 | 225228000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
9353 | 4704 | 4704 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620566092468000 | 620566229944000 | 137476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4703 | STATEMENT | |
9353 | 4706 | 4706 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620566555404000 | 620566692322000 | 136918000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4705 | STATEMENT | |
9353 | 4708 | 4708 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620566960355000 | 620567049187000 | 88832000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4707 | STATEMENT | |
9353 | 4710 | 4710 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620567336360000 | 620567462538000 | 126178000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4709 | STATEMENT | |
9353 | 4712 | 4712 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620567696894000 | 620567786433000 | 89539000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4711 | STATEMENT | |
9353 | 4714 | 4714 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620568013274000 | 620568100637000 | 87363000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4713 | STATEMENT | |
9353 | 4716 | 4716 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620568408430000 | 620568496773000 | 88343000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4715 | STATEMENT | |
9353 | 4718 | 4718 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620568709879000 | 620568796427000 | 86548000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4717 | STATEMENT | |
9353 | 4720 | 4720 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620569016964000 | 620569103996000 | 87032000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4719 | STATEMENT | |
9353 | 4722 | 4722 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620569437903000 | 620569574404000 | 136501000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 4721 | STATEMENT | |
9363 | 6 | 6 | transaction | COMMITTED | 421734165913040 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620476523680000 | 620476549960000 | 26280000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
9363 | 12 | 12 | transaction | COMMITTED | 421734165913040 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620479748822000 | 620479915976000 | 167154000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
9363 | 15 | 15 | transaction | COMMITTED | 421734165913040 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620480704643000 | 620481270739000 | 566096000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
9363 | 19 | 19 | transaction | COMMITTED | 421734165913040 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 620483592562000 | 620483795577000 | 203015000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT |
|