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 | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1955300545000 | 1955308815000 | 8270000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1955387068000 | 1955395381000 | 8313000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1955779740000 | 1955786282000 | 6542000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1955889527000 | 1955895620000 | 6093000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1940533110000 | 1941325094000 | 791984000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1949303737000 | 1949309063000 | 5326000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1949381109000 | 1949408740000 | 27631000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1949465982000 | 1949791319000 | 325337000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1952398616000 | 1952419523000 | 20907000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1954613876000 | 1954623188000 | 9312000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421286244284160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1779049517000 | 1779495810000 | 446293000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2915 | 36 | 36 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223998917608000 | 223999164882000 | 247274000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
2915 | 12 | 12 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223831208646000 | 223831351834000 | 143188000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
2915 | 15 | 15 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223832138302000 | 223832626026000 | 487724000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
2915 | 19 | 19 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223834043530000 | 223834188771000 | 145241000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
2915 | 21 | 21 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223834622172000 | 223835115048000 | 492876000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
2915 | 23 | 23 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223835797762000 | 223836034469000 | 236707000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
2915 | 26 | 26 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223844171083000 | 223844962749000 | 791666000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
2915 | 30 | 30 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223974813072000 | 223975178158000 | 365086000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
2915 | 32 | 32 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223987400468000 | 223988321237000 | 920769000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
2915 | 34 | 34 | transaction | COMMITTED | 421286244285032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223991592771000 | 223991864791000 | 272020000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
2919 | 6 | 6 | transaction | COMMITTED | 421286244286776 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 223988181634000 | 223988207392000 | 25758000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2921 | 6 | 6 | transaction | COMMITTED | 421286244285904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 224000517756000 | 224000543286000 | 25530000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|