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 | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1789852865000 | 1789860092000 | 7227000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1789937858000 | 1789945980000 | 8122000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1790311416000 | 1790317812000 | 6396000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1790411253000 | 1790417091000 | 5838000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1761788541000 | 1763218258000 | 1429717000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1782419626000 | 1782425551000 | 5925000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1782501131000 | 1782529869000 | 28738000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1782575835000 | 1783320561000 | 744726000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1786167460000 | 1786190086000 | 22626000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1789149352000 | 1789158902000 | 9550000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421787712014080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1586584516000 | 1586924346000 | 339830000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
8061 | 6 | 6 | transaction | COMMITTED | 421787712014952 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 626634171473000 | 626634216335000 | 44862000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|