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 | |
7089 | 6 | 6 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342063570091000 | 342063610664000 | 40573000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
7089 | 12 | 12 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342066768928000 | 342066940670000 | 171742000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
7089 | 15 | 15 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342067824373000 | 342068298141000 | 473768000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
7089 | 19 | 19 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342069727926000 | 342069837754000 | 109828000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
7089 | 21 | 21 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342070474169000 | 342070963587000 | 489418000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
7089 | 23 | 23 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342071674382000 | 342071929136000 | 254754000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
7089 | 27 | 27 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342080684729000 | 342081640532000 | 955803000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
7091 | 6 | 6 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342095491741000 | 342095534937000 | 43196000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
7091 | 12 | 12 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342098280387000 | 342098415672000 | 135285000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
7091 | 15 | 15 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342099202689000 | 342099620955000 | 418266000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
7091 | 19 | 19 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342100914520000 | 342101021582000 | 107062000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
7091 | 21 | 21 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342101539961000 | 342102026417000 | 486456000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
7091 | 23 | 23 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342102626703000 | 342102860996000 | 234293000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
7091 | 26 | 26 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 342109491939000 | 342110267032000 | 775093000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT |
|