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 | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1608371997000 | 1608383391000 | 11394000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1608498736000 | 1608511254000 | 12518000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1609094434000 | 1609104096000 | 9662000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1609241344000 | 1609249732000 | 8388000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1571127428000 | 1572585127000 | 1457699000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1595572905000 | 1595602660000 | 29755000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1595789295000 | 1595856836000 | 67541000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1595968158000 | 1597406671000 | 1438513000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1602453813000 | 1602494139000 | 40326000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1607294856000 | 1607311903000 | 17047000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421764316104448 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1406284894000 | 1406657306000 | 372412000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1953 | 6 | 6 | transaction | COMMITTED | 421764316105320 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 159683896614000 | 159683947904000 | 51290000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|