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 | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1892741259000 | 1892752562000 | 11303000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1892854279000 | 1892865549000 | 11270000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1893383350000 | 1893391131000 | 7781000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1893505049000 | 1893511955000 | 6906000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1865506072000 | 1868078868000 | 2572796000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1883132864000 | 1883145546000 | 12682000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1883277730000 | 1883314989000 | 37259000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1883362925000 | 1884737765000 | 1374840000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1888604958000 | 1888633616000 | 28658000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1891802595000 | 1891816259000 | 13664000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
3251 | 6 | 6 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409399701941000 | 409399754642000 | 52701000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
3251 | 12 | 12 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409403799692000 | 409404010374000 | 210682000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
3251 | 15 | 15 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409405091260000 | 409405607889000 | 516629000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
3251 | 19 | 19 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409407378764000 | 409407508068000 | 129304000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
3251 | 21 | 21 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409408158293000 | 409408686335000 | 528042000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
3251 | 23 | 23 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409409382472000 | 409409651617000 | 269145000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
3251 | 27 | 27 | transaction | COMMITTED | 421122205522536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409417215464000 | 409418014964000 | 799500000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
3253 | 6 | 6 | transaction | COMMITTED | 421122205523408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409474507999000 | 409474553937000 | 45938000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
3253 | 12 | 12 | transaction | COMMITTED | 421122205523408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409477555560000 | 409477734338000 | 178778000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
3253 | 15 | 15 | transaction | COMMITTED | 421122205523408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409478657970000 | 409479116401000 | 458431000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
3253 | 19 | 19 | transaction | COMMITTED | 421122205523408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409480693406000 | 409480828569000 | 135163000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
3253 | 21 | 21 | transaction | COMMITTED | 421122205523408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409481280652000 | 409481784424000 | 503772000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
3253 | 23 | 23 | transaction | COMMITTED | 421122205523408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409482327484000 | 409482584194000 | 256710000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
3253 | 26 | 26 | transaction | COMMITTED | 421122205523408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 409491139153000 | 409491999169000 | 860016000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
35 | 1 | 1 | transaction | COMMITTED | 421122205521664 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1669676200000 | 1669993409000 | 317209000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL |
|