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 | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1795811873000 | 1795823210000 | 11337000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1795938718000 | 1795963420000 | 24702000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1796518798000 | 1796527725000 | 8927000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1796642253000 | 1796649932000 | 7679000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1766476893000 | 1767726005000 | 1249112000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1786794243000 | 1786811831000 | 17588000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1786932631000 | 1786983156000 | 50525000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1787042783000 | 1787602697000 | 559914000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1791765430000 | 1791800454000 | 35024000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1794928564000 | 1794943208000 | 14644000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421187549374208 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1595329491000 | 1595872190000 | 542699000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
5629 | 33 | 33 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289690396413000 | 289690553305000 | 156892000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
5629 | 35 | 35 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289691054819000 | 289691464399000 | 409580000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 34 | STATEMENT | |
5629 | 37 | 37 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289691988998000 | 289692140524000 | 151526000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 36 | STATEMENT | |
5629 | 92 | 92 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289766065293000 | 289766262618000 | 197325000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 91 | STATEMENT | |
5629 | 19 | 19 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289681549020000 | 289681702495000 | 153475000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
5629 | 21 | 21 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289682198485000 | 289682342698000 | 144213000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
5629 | 24 | 24 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289683794036000 | 289683969950000 | 175914000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
5629 | 27 | 27 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289688287303000 | 289688508157000 | 220854000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
5629 | 29 | 29 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289689103012000 | 289689286606000 | 183594000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 28 | STATEMENT | |
5629 | 31 | 31 | transaction | COMMITTED | 421187549375952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289689777690000 | 289689964119000 | 186429000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 30 | STATEMENT | |
5631 | 6 | 6 | transaction | COMMITTED | 421187549375080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 289760007571000 | 289760062746000 | 55175000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|