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 | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2240607043000 | 2240615945000 | 8902000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2240695940000 | 2240704263000 | 8323000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2241138584000 | 2241144973000 | 6389000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2241242253000 | 2241247968000 | 5715000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2219535824000 | 2221218210000 | 1682386000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2231127414000 | 2231139204000 | 11790000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2231210954000 | 2231237443000 | 26489000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2231283571000 | 2232011516000 | 727945000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2235642890000 | 2235665392000 | 22502000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2239893717000 | 2239904420000 | 10703000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422158314014464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1973674571000 | 1973983583000 | 309012000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2073 | 6 | 6 | transaction | COMMITTED | 422158314015336 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 145906089566000 | 145906134043000 | 44477000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|