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 | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1534458909000 | 1534467986000 | 9077000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1534547543000 | 1534556020000 | 8477000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1534975528000 | 1534982412000 | 6884000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1535077958000 | 1535083887000 | 5929000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1519458387000 | 1520158737000 | 700350000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1527864696000 | 1527871666000 | 6970000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1527951903000 | 1528000789000 | 48886000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1528035634000 | 1528783110000 | 747476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1531256592000 | 1531281495000 | 24903000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1533773405000 | 1533786753000 | 13348000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421448485766912 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1390471231000 | 1390725198000 | 253967000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
10679 | 6 | 6 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697395742805000 | 697395788567000 | 45762000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
10679 | 12 | 12 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697401691310000 | 697401894430000 | 203120000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
10679 | 15 | 15 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697404845747000 | 697405712829000 | 867082000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
10679 | 19 | 19 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697407239519000 | 697407457995000 | 218476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
10679 | 21 | 21 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697408083445000 | 697408583238000 | 499793000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
10679 | 23 | 23 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697409171292000 | 697409417785000 | 246493000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
10679 | 26 | 26 | transaction | COMMITTED | 421448485769528 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697421982641000 | 697422891560000 | 908919000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
10681 | 6 | 6 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697510922090000 | 697511001535000 | 79445000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
10681 | 12 | 12 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697513870156000 | 697514062313000 | 192157000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
10681 | 15 | 15 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697515195421000 | 697515954385000 | 758964000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
10681 | 19 | 19 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697517334489000 | 697517463708000 | 129219000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
10681 | 21 | 21 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697518168662000 | 697519139946000 | 971284000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
10681 | 23 | 23 | transaction | COMMITTED | 421448485767784 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697520162721000 | 697521271183000 | 1108462000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
10683 | 6 | 6 | transaction | COMMITTED | 421448485768656 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 697519894904000 | 697519923773000 | 28869000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|