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 | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1582526705000 | 1582535378000 | 8673000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1582620427000 | 1582630166000 | 9739000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1583080791000 | 1583088412000 | 7621000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1583213957000 | 1583221254000 | 7297000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1562844169000 | 1563802455000 | 958286000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1575271646000 | 1575281793000 | 10147000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1575367938000 | 1575401197000 | 33259000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1575449858000 | 1576172653000 | 722795000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1579263972000 | 1579289940000 | 25968000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1581821812000 | 1581834743000 | 12931000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421754048444160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1407204175000 | 1407527293000 | 323118000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2663 | 6 | 6 | transaction | COMMITTED | 421754048445904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383519042794000 | 383519069102000 | 26308000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2665 | 9 | 9 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383509384563000 | 383509416708000 | 32145000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT | |
2665 | 12 | 12 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383510205495000 | 383510532344000 | 326849000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
2665 | 14 | 14 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383511085504000 | 383511258964000 | 173460000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 13 | STATEMENT | |
2665 | 16 | 16 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383511816756000 | 383512003580000 | 186824000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 15 | STATEMENT | |
2665 | 18 | 18 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383512515953000 | 383512669102000 | 153149000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 17 | STATEMENT | |
2665 | 22 | 22 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383513473549000 | 383513547326000 | 73777000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 21 | STATEMENT | |
2665 | 24 | 24 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383513865915000 | 383514561498000 | 695583000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
2665 | 29 | 29 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383517791140000 | 383517957371000 | 166231000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 28 | STATEMENT | |
2665 | 32 | 32 | transaction | COMMITTED | 421754048445032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 383519424253000 | 383519558051000 | 133798000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT |
|