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 | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1870304063000 | 1870316256000 | 12193000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1870448664000 | 1870467187000 | 18523000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1871051837000 | 1871061764000 | 9927000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1871200273000 | 1871209647000 | 9374000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1833642058000 | 1835341810000 | 1699752000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1858036456000 | 1858052467000 | 16011000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1858198654000 | 1858257238000 | 58584000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1858346494000 | 1860141059000 | 1794565000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1865360888000 | 1865396864000 | 35976000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1869296548000 | 1869311621000 | 15073000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421871545460480 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1663003846000 | 1663349483000 | 345637000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
6119 | 6 | 6 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814861906313000 | 814861957591000 | 51278000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
6119 | 11 | 11 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814864823359000 | 814864930537000 | 107178000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
6119 | 15 | 15 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814866492792000 | 814866724216000 | 231424000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
6119 | 17 | 17 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814867733438000 | 814868463804000 | 730366000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
6119 | 19 | 19 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814869228130000 | 814869489124000 | 260994000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
6119 | 21 | 21 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814870220182000 | 814870332098000 | 111916000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
6119 | 25 | 25 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814879270797000 | 814879388925000 | 118128000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 24 | STATEMENT | |
6119 | 27 | 27 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814879808777000 | 814879922118000 | 113341000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
6119 | 29 | 29 | transaction | COMMITTED | 421871545461352 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814880247841000 | 814880379515000 | 131674000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 28 | STATEMENT | |
6121 | 6 | 6 | transaction | COMMITTED | 421871545462224 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 814879061340000 | 814879121272000 | 59932000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|