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 | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1505379104000 | 1505386408000 | 7304000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1505459125000 | 1505467483000 | 8358000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1505884224000 | 1505890733000 | 6509000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1505989718000 | 1505995273000 | 5555000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490740663000 | 1491459355000 | 718692000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1498418249000 | 1498428086000 | 9837000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1498498773000 | 1498526331000 | 27558000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1498557653000 | 1499570829000 | 1013176000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1502404172000 | 1502423860000 | 19688000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1504740969000 | 1504750713000 | 9744000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421361834268416 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1355333892000 | 1355645725000 | 311833000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
11489 | 6 | 6 | transaction | COMMITTED | 421361834270160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599732465124000 | 599732679127000 | 214003000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
11489 | 10 | 10 | transaction | COMMITTED | 421361834270160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599734841594000 | 599735042317000 | 200723000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 9 | STATEMENT | |
11489 | 12 | 12 | transaction | COMMITTED | 421361834270160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599739595765000 | 599740198812000 | 603047000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
11489 | 14 | 14 | transaction | COMMITTED | 421361834270160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599743348601000 | 599743535402000 | 186801000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 13 | STATEMENT | |
11489 | 16 | 16 | transaction | COMMITTED | 421361834270160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599744790643000 | 599744946466000 | 155823000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 15 | STATEMENT | |
11489 | 18 | 18 | transaction | COMMITTED | 421361834270160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599794174076000 | 599794363354000 | 189278000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 17 | STATEMENT | |
11489 | 20 | 20 | transaction | COMMITTED | 421361834270160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599794713493000 | 599794739533000 | 26040000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 19 | STATEMENT | |
11489 | 22 | 22 | transaction | COMMITTED | 421361834270160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599795158563000 | 599795529569000 | 371006000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 21 | STATEMENT | |
11491 | 32 | 32 | transaction | COMMITTED | 421361834271904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599778080500000 | 599778325066000 | 244566000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
11491 | 34 | 34 | transaction | COMMITTED | 421361834271904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599779109884000 | 599779730058000 | 620174000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
11491 | 36 | 36 | transaction | COMMITTED | 421361834271904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599780480158000 | 599780741667000 | 261509000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
11491 | 17 | 17 | transaction | COMMITTED | 421361834271904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599766550674000 | 599767098530000 | 547856000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
11491 | 19 | 19 | transaction | COMMITTED | 421361834271904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599767842419000 | 599768072024000 | 229605000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
11491 | 21 | 21 | transaction | COMMITTED | 421361834271904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 599768787583000 | 599769006470000 | 218887000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT |
|