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 | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1591616510000 | 1591626694000 | 10184000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1591730007000 | 1591738913000 | 8906000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1592204054000 | 1592211262000 | 7208000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1592311117000 | 1592317117000 | 6000000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1574997889000 | 1575769091000 | 771202000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1583508549000 | 1583518023000 | 9474000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1583603780000 | 1583636258000 | 32478000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1583676607000 | 1584631587000 | 954980000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1587866520000 | 1587891189000 | 24669000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1590815680000 | 1590827906000 | 12226000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421856027002624 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1420495904000 | 1420764685000 | 268781000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
4402 | 6 | 6 | transaction | COMMITTED | 421856027004368 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 488937465962000 | 488937513808000 | 47846000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
4403 | 3 | 3 | transaction | COMMITTED | 421856027003496 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 488903986765000 | 488905732661000 | 1745896000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT |
|