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 | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1757093922000 | 1757106784000 | 12862000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1757219862000 | 1757232167000 | 12305000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1757810760000 | 1757820699000 | 9939000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1757951651000 | 1757960553000 | 8902000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1719381327000 | 1720968705000 | 1587378000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1744554241000 | 1744571440000 | 17199000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1744750300000 | 1744818161000 | 67861000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1744914753000 | 1746835308000 | 1920555000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1751730168000 | 1751772628000 | 42460000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1756088414000 | 1756107780000 | 19366000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421815073584896 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1559412394000 | 1559745853000 | 333459000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
3216 | 32 | 32 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222322496450000 | 222323106255000 | 609805000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
3216 | 36 | 36 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222423849146000 | 222424084350000 | 235204000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
3216 | 38 | 38 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222434248115000 | 222435208939000 | 960824000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
3216 | 40 | 40 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222444613970000 | 222445020094000 | 406124000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 39 | STATEMENT | |
3216 | 42 | 42 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222453276557000 | 222453614436000 | 337879000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 41 | STATEMENT | |
3216 | 44 | 44 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222473527697000 | 222473938288000 | 410591000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 43 | STATEMENT | |
3216 | 24 | 24 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222316581336000 | 222316693655000 | 112319000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
3216 | 26 | 26 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222318717013000 | 222318813780000 | 96767000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
3216 | 28 | 28 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222319101648000 | 222319193778000 | 92130000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 27 | STATEMENT | |
3216 | 30 | 30 | transaction | COMMITTED | 421815073589256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222319684939000 | 222320033825000 | 348886000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
3217 | 3 | 3 | transaction | COMMITTED | 421815073585768 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222279063423000 | 222279364965000 | 301542000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
3219 | 6 | 6 | transaction | COMMITTED | 421815073586640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222409883588000 | 222409940159000 | 56571000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
3219 | 12 | 12 | transaction | COMMITTED | 421815073586640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222413005055000 | 222413191600000 | 186545000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
3219 | 15 | 15 | transaction | COMMITTED | 421815073586640 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 222418257710000 | 222418988723000 | 731013000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT |
|