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 | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490548364000 | 1490555194000 | 6830000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490626006000 | 1490633758000 | 7752000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490999153000 | 1491005885000 | 6732000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1491152423000 | 1491162581000 | 10158000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1475615785000 | 1477142210000 | 1526425000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484364816000 | 1484372492000 | 7676000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484481430000 | 1484509282000 | 27852000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484549282000 | 1484871176000 | 321894000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1487651142000 | 1487672250000 | 21108000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1489938042000 | 1489947740000 | 9698000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421999075563264 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1333208228000 | 1333400436000 | 192208000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
9347 | 6 | 6 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 444384922714000 | 444384979071000 | 56357000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
9347 | 12 | 12 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 444387865594000 | 444388166211000 | 300617000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
9347 | 15 | 15 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 444389199168000 | 444389917945000 | 718777000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
9347 | 19 | 19 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 444391328473000 | 444391484476000 | 156003000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
9347 | 21 | 21 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 444392047455000 | 444392879971000 | 832516000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
9347 | 23 | 23 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 444393667729000 | 444394025597000 | 357868000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
9347 | 27 | 27 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 444401825682000 | 444402717434000 | 891752000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
9349 | 6 | 6 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 444444464163000 | 444444506731000 | 42568000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|