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 | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1796095061000 | 1796109000000 | 13939000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1796240005000 | 1796255032000 | 15027000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1796928062000 | 1796940873000 | 12811000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1797116516000 | 1797125632000 | 9116000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1753695250000 | 1755240564000 | 1545314000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1782808166000 | 1782834543000 | 26377000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1783036835000 | 1783120515000 | 83680000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1783216121000 | 1785244505000 | 2028384000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1790752497000 | 1790796893000 | 44396000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1794995763000 | 1795013370000 | 17607000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421268097406720 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1569289556000 | 1569730219000 | 440663000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
9369 | 36 | 36 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532883992288000 | 532884260141000 | 267853000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
9369 | 12 | 12 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532737993397000 | 532738129695000 | 136298000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
9369 | 15 | 15 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532739000040000 | 532739613225000 | 613185000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
9369 | 19 | 19 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532740904764000 | 532741011900000 | 107136000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
9369 | 21 | 21 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532741466109000 | 532741924279000 | 458170000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
9369 | 23 | 23 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532742504748000 | 532742729740000 | 224992000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
9369 | 26 | 26 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532749471771000 | 532750261708000 | 789937000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
9369 | 30 | 30 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532868999065000 | 532869208128000 | 209063000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
9369 | 32 | 32 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532876599400000 | 532877253771000 | 654371000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
9369 | 34 | 34 | transaction | COMMITTED | 421268097408464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532881683997000 | 532881983325000 | 299328000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
9371 | 6 | 6 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532830585255000 | 532830627977000 | 42722000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
9371 | 12 | 12 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532833266045000 | 532833400011000 | 133966000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
9371 | 15 | 15 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532834307972000 | 532834877557000 | 569585000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
9371 | 19 | 19 | transaction | COMMITTED | 421268097407592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 532836105201000 | 532836205913000 | 100712000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT |
|