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 | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1886724812000 | 1886737545000 | 12733000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1886855872000 | 1886872614000 | 16742000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1887486778000 | 1887497108000 | 10330000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1887644282000 | 1887653145000 | 8863000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1848876718000 | 1850302299000 | 1425581000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1875406518000 | 1875425878000 | 19360000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1875580018000 | 1875635807000 | 55789000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1875724767000 | 1876813939000 | 1089172000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1881613740000 | 1881649216000 | 35476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1885567697000 | 1885588888000 | 21191000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421369714202368 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1687864101000 | 1688171502000 | 307401000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
8775 | 6 | 6 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 511871146002000 | 511871188130000 | 42128000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
8775 | 12 | 12 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 511874134425000 | 511874275119000 | 140694000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
8775 | 15 | 15 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 511875171086000 | 511875582205000 | 411119000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
8775 | 19 | 19 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 511877086570000 | 511877186201000 | 99631000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
8775 | 21 | 21 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 511877769550000 | 511878254359000 | 484809000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
8775 | 23 | 23 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 511878939582000 | 511879175253000 | 235671000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
8775 | 26 | 26 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 511887245915000 | 511888051526000 | 805611000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
8775 | 30 | 30 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 512000452346000 | 512000649797000 | 197451000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
8775 | 32 | 32 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 512004893808000 | 512005462049000 | 568241000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
8775 | 34 | 34 | transaction | COMMITTED | 421369714204112 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 512008457065000 | 512008715807000 | 258742000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
8777 | 6 | 6 | transaction | COMMITTED | 421369714203240 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 512008232682000 | 512008261432000 | 28750000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|