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 | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1903902429000 | 1903917297000 | 14868000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1904078738000 | 1904094692000 | 15954000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1904812098000 | 1904823611000 | 11513000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1904981458000 | 1904992162000 | 10704000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1860488483000 | 1862015169000 | 1526686000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1889782354000 | 1889817014000 | 34660000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1890116413000 | 1890219788000 | 103375000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1890329651000 | 1891204219000 | 874568000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1898269737000 | 1898319715000 | 49978000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1902702158000 | 1902720123000 | 17965000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421884459820800 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1702145814000 | 1702472835000 | 327021000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2702 | 6 | 6 | transaction | COMMITTED | 421884459823416 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 136344420628000 | 136344475019000 | 54391000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2703 | 3 | 3 | transaction | COMMITTED | 421884459821672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 136294388539000 | 136295132773000 | 744234000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
2705 | 6 | 6 | transaction | COMMITTED | 421884459822544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 136340711136000 | 136340756953000 | 45817000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2705 | 9 | 9 | transaction | COMMITTED | 421884459822544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 136342170534000 | 136342346828000 | 176294000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT |
|