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 | |
5760 | 32 | 32 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383335792978000 | 383336395626000 | 602648000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
5760 | 36 | 36 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383398645607000 | 383398840125000 | 194518000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
5760 | 38 | 38 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383403161848000 | 383403808791000 | 646943000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
5760 | 40 | 40 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383407566881000 | 383408500996000 | 934115000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 39 | STATEMENT | |
5760 | 42 | 42 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383409973819000 | 383410471362000 | 497543000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 41 | STATEMENT | |
5760 | 21 | 21 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383318461757000 | 383318604840000 | 143083000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
5760 | 24 | 24 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383327025095000 | 383327127784000 | 102689000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
5760 | 26 | 26 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383333978591000 | 383334083761000 | 105170000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
5760 | 28 | 28 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383334353922000 | 383334445638000 | 91716000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 27 | STATEMENT | |
5760 | 30 | 30 | transaction | COMMITTED | 421734165915656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383334915203000 | 383335255237000 | 340034000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
5761 | 3 | 3 | transaction | COMMITTED | 421734165914784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383279925726000 | 383280367628000 | 441902000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
5763 | 6 | 6 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383403462586000 | 383403483424000 | 20838000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
5763 | 11 | 11 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383405248707000 | 383405328339000 | 79632000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
5763 | 15 | 15 | transaction | COMMITTED | 421734165912168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383406236839000 | 383406361348000 | 124509000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT |
|