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 | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1653963277000 | 1653977809000 | 14532000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1654114972000 | 1654128786000 | 13814000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1654901281000 | 1654913136000 | 11855000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1655079127000 | 1655089096000 | 9969000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1613693772000 | 1615087507000 | 1393735000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1638071585000 | 1638087733000 | 16148000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1638330810000 | 1638470286000 | 139476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1638610283000 | 1641181260000 | 2570977000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1647815180000 | 1647881332000 | 66152000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421201288116840 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1652849376000 | 1652881361000 | 31985000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421201288115968 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1456561874000 | 1456835675000 | 273801000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
7636 | 38 | 38 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446697662480000 | 446697941086000 | 278606000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
7636 | 40 | 40 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446724116185000 | 446724506718000 | 390533000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 39 | STATEMENT | |
7636 | 15 | 15 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446571107930000 | 446571688364000 | 580434000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
7636 | 19 | 19 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446572809117000 | 446572936013000 | 126896000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
7636 | 21 | 21 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446573372469000 | 446573695338000 | 322869000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
7636 | 23 | 23 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446574212788000 | 446574433143000 | 220355000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
7636 | 27 | 27 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446579661664000 | 446580247586000 | 585922000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
7636 | 32 | 32 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446674387784000 | 446674596382000 | 208598000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
7636 | 34 | 34 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446679214036000 | 446680115991000 | 901955000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
7636 | 36 | 36 | transaction | COMMITTED | 421201288119456 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446695922145000 | 446696380103000 | 457958000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
7637 | 6 | 6 | transaction | COMMITTED | 421201288120328 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446561838452000 | 446561864548000 | 26096000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
7637 | 12 | 12 | transaction | COMMITTED | 421201288120328 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446576641760000 | 446576779352000 | 137592000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
7637 | 15 | 15 | transaction | COMMITTED | 421201288120328 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446580954271000 | 446581558729000 | 604458000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
7637 | 19 | 19 | transaction | COMMITTED | 421201288120328 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 446582908398000 | 446583044355000 | 135957000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT |
|