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 | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1898505227000 | 1898524293000 | 19066000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1898699867000 | 1898718423000 | 18556000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1899611746000 | 1899626827000 | 15081000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1899808470000 | 1899821046000 | 12576000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1865516396000 | 1867125526000 | 1609130000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1884661970000 | 1884671454000 | 9484000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1884820782000 | 1884883977000 | 63195000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1884956456000 | 1886996992000 | 2040536000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1892230564000 | 1892293659000 | 63095000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1897107983000 | 1897137031000 | 29048000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421214076028672 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1654128307000 | 1654548542000 | 420235000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
2845 | 6 | 6 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 371226022762000 | 371226125160000 | 102398000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
2845 | 9 | 9 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 371240719832000 | 371240936430000 | 216598000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT | |
2845 | 11 | 11 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 371241844828000 | 371244060366000 | 2215538000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
2845 | 16 | 16 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 371275121004000 | 371276088785000 | 967781000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 15 | STATEMENT | |
2845 | 18 | 18 | transaction | COMMITTED | 421214076029544 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 371279689690000 | 371280081227000 | 391537000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 17 | STATEMENT | |
2847 | 6 | 6 | transaction | COMMITTED | 421214076030416 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 371277756410000 | 371277780759000 | 24349000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|