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 | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1495147825000 | 1495155429000 | 7604000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1495238924000 | 1495248396000 | 9472000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1495687128000 | 1495696763000 | 9635000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1495799758000 | 1495805845000 | 6087000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1479514852000 | 1480291356000 | 776504000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1488792670000 | 1488800535000 | 7865000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1488915613000 | 1488944940000 | 29327000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1488982889000 | 1489321951000 | 339062000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1491722497000 | 1491744326000 | 21829000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1494424594000 | 1494438286000 | 13692000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421229595887360 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1338955291000 | 1339249740000 | 294449000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1582 | 6 | 6 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 185019582755000 | 185019628046000 | 45291000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
1582 | 11 | 11 | transaction | COMMITTED | 421229595888232 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 185021564705000 | 185021662458000 | 97753000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
1583 | 6 | 6 | transaction | COMMITTED | 421229595889104 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 185020497739000 | 185020532925000 | 35186000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|