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 | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1730850020000 | 1730863204000 | 13184000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1730977757000 | 1730990803000 | 13046000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1731614850000 | 1731625887000 | 11037000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1731774184000 | 1731783765000 | 9581000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1690932481000 | 1692617259000 | 1684778000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1717282854000 | 1717294647000 | 11793000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1717486997000 | 1717554908000 | 67911000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1717671541000 | 1719925631000 | 2254090000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1724958561000 | 1724995740000 | 37179000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1729791130000 | 1729806814000 | 15684000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421461534713600 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1529093621000 | 1529420581000 | 326960000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1951 | 7 | 7 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 234312895441000 | 234313298829000 | 403388000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 6 | STATEMENT | |
1951 | 9 | 9 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 234313541360000 | 234313724708000 | 183348000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT | |
1951 | 11 | 11 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 234313874984000 | 234313896156000 | 21172000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
1951 | 13 | 13 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 234314166042000 | 234314290598000 | 124556000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 12 | STATEMENT | |
1951 | 15 | 15 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 234314478285000 | 234314510441000 | 32156000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
1951 | 18 | 18 | transaction | COMMITTED | 421461534714472 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 234326639395000 | 234326837534000 | 198139000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 17 | STATEMENT | |
1953 | 6 | 6 | transaction | COMMITTED | 421461534715344 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 234326517785000 | 234326559615000 | 41830000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|