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 | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484977980000 | 1484988844000 | 10864000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1485064128000 | 1485072348000 | 8220000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1485453589000 | 1485460178000 | 6589000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1485559139000 | 1485564845000 | 5706000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1469945861000 | 1470725143000 | 779282000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1477745304000 | 1477752697000 | 7393000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1477825192000 | 1477853043000 | 27851000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1477893652000 | 1478888972000 | 995320000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1481531111000 | 1481556225000 | 25114000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484306250000 | 1484319254000 | 13004000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421201153312512 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1334716076000 | 1335001663000 | 285587000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1131 | 6 | 6 | transaction | COMMITTED | 421201153313384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142570765587000 | 142570818883000 | 53296000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|