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 | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1647322221000 | 1647330293000 | 8072000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1647409530000 | 1647417683000 | 8153000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1647801240000 | 1647807674000 | 6434000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1647919441000 | 1647925490000 | 6049000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1627748302000 | 1628503171000 | 754869000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1638306242000 | 1638315192000 | 8950000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1638398795000 | 1638432554000 | 33759000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1638467140000 | 1640958324000 | 2491184000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1644190993000 | 1644212989000 | 21996000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1646629260000 | 1646639145000 | 9885000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421174075639552 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484657277000 | 1485037523000 | 380246000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
9371 | 6 | 6 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497517280356000 | 497517322769000 | 42413000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
9371 | 12 | 12 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497520069128000 | 497520207768000 | 138640000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
9371 | 15 | 15 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497520923454000 | 497521384614000 | 461160000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
9371 | 19 | 19 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497522641337000 | 497522747518000 | 106181000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
9371 | 21 | 21 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497523229489000 | 497523738127000 | 508638000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
9371 | 23 | 23 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497524458811000 | 497524760780000 | 301969000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
9371 | 26 | 26 | transaction | COMMITTED | 421174075640424 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497532184076000 | 497533056918000 | 872842000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
9373 | 6 | 6 | transaction | COMMITTED | 421174075642168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497524310293000 | 497524351608000 | 41315000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
9373 | 12 | 12 | transaction | COMMITTED | 421174075642168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497529253184000 | 497529396055000 | 142871000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
9373 | 15 | 15 | transaction | COMMITTED | 421174075642168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497533052252000 | 497533582161000 | 529909000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
9373 | 19 | 19 | transaction | COMMITTED | 421174075642168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497539065571000 | 497539172796000 | 107225000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
9373 | 21 | 21 | transaction | COMMITTED | 421174075642168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497540753214000 | 497541272855000 | 519641000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
9373 | 23 | 23 | transaction | COMMITTED | 421174075642168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497541859913000 | 497542089886000 | 229973000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
9373 | 27 | 27 | transaction | COMMITTED | 421174075642168 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 497557330030000 | 497558067437000 | 737407000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT |
|