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 | |
4883 | 7638 | 7638 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270884226498000 | 270884311784000 | 85286000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7637 | STATEMENT | |
4883 | 7640 | 7640 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270884518778000 | 270884616066000 | 97288000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7639 | STATEMENT | |
4883 | 7642 | 7642 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270884825667000 | 270884911828000 | 86161000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7641 | STATEMENT | |
4883 | 7644 | 7644 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270885204791000 | 270885336772000 | 131981000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7643 | STATEMENT | |
4883 | 7626 | 7626 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270882165634000 | 270882252183000 | 86549000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7625 | STATEMENT | |
4883 | 7628 | 7628 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270882516757000 | 270882602905000 | 86148000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7627 | STATEMENT | |
4883 | 7630 | 7630 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270882864289000 | 270882950809000 | 86520000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7629 | STATEMENT | |
4883 | 7632 | 7632 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270883212509000 | 270883296053000 | 83544000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7631 | STATEMENT | |
4883 | 7634 | 7634 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270883552491000 | 270883634519000 | 82028000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7633 | STATEMENT | |
4883 | 7636 | 7636 | transaction | COMMITTED | 421361834269288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270883893785000 | 270883977549000 | 83764000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7635 | STATEMENT | |
4906 | 6 | 6 | transaction | COMMITTED | 421361834271032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270872170537000 | 270872188052000 | 17515000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
4906 | 11 | 11 | transaction | COMMITTED | 421361834271032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270874243635000 | 270874368853000 | 125218000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
4906 | 15 | 15 | transaction | COMMITTED | 421361834271032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270875345936000 | 270875486964000 | 141028000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
4906 | 17 | 17 | transaction | COMMITTED | 421361834271032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 270876097232000 | 270876838479000 | 741247000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT |
|