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 | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1900376928000 | 1900392463000 | 15535000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1900523381000 | 1900538506000 | 15125000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1901246383000 | 1901259351000 | 12968000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1901422101000 | 1901432621000 | 10520000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1861239009000 | 1862641460000 | 1402451000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1887456062000 | 1887482520000 | 26458000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1887762169000 | 1887867377000 | 105208000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1888020003000 | 1889436277000 | 1416274000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1894599732000 | 1894644703000 | 44971000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1899176206000 | 1899195969000 | 19763000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422101279590144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1689850355000 | 1690314924000 | 464569000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2351 | 6 | 6 | transaction | COMMITTED | 422101279591016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 482684504673000 | 482684546351000 | 41678000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|