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 | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1554093868000 | 1554101147000 | 7279000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1554169117000 | 1554177113000 | 7996000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1554551677000 | 1554558335000 | 6658000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1554656467000 | 1554662156000 | 5689000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1538397213000 | 1539059758000 | 662545000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1547088386000 | 1547095154000 | 6768000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1547170397000 | 1547197975000 | 27578000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1547228507000 | 1548266879000 | 1038372000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1550784259000 | 1550803076000 | 18817000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1553399018000 | 1553409086000 | 10068000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421288330548992 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1407323644000 | 1407570814000 | 247170000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
559 | 6 | 6 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 52569009738000 | 52569054405000 | 44667000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
559 | 12 | 12 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 52572825783000 | 52572959036000 | 133253000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
559 | 15 | 15 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 52574023873000 | 52574580336000 | 556463000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
559 | 19 | 19 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 52576227734000 | 52576449874000 | 222140000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
559 | 21 | 21 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 52577046557000 | 52577518175000 | 471618000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
559 | 23 | 23 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 52578131764000 | 52578350827000 | 219063000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
559 | 26 | 26 | transaction | COMMITTED | 421288330549864 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 52585151720000 | 52585894245000 | 742525000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
561 | 6 | 6 | transaction | COMMITTED | 421288330550736 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 52715467484000 | 52715513326000 | 45842000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|