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 | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1772169855000 | 1772182460000 | 12605000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1772288967000 | 1772301595000 | 12628000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1772888196000 | 1772898637000 | 10441000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1773028650000 | 1773037433000 | 8783000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1733615398000 | 1734912809000 | 1297411000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1759041598000 | 1759070349000 | 28751000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1759256483000 | 1759332665000 | 76182000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1759423762000 | 1760343273000 | 919511000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1767025471000 | 1767062183000 | 36712000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1771210071000 | 1771229301000 | 19230000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422023192770304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1539660143000 | 1540059124000 | 398981000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
4579 | 33 | 33 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745034905307000 | 745035505310000 | 600003000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
4579 | 11 | 11 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745019240514000 | 745019323865000 | 83351000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
4579 | 15 | 15 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745020395869000 | 745020585454000 | 189585000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
4579 | 17 | 17 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745021209563000 | 745021664195000 | 454632000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
4579 | 19 | 19 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745022401109000 | 745022661147000 | 260038000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
4579 | 21 | 21 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745023383279000 | 745023534296000 | 151017000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
4579 | 25 | 25 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745031930345000 | 745032045132000 | 114787000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 24 | STATEMENT | |
4579 | 27 | 27 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745032479140000 | 745032569689000 | 90549000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
4579 | 29 | 29 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745032942530000 | 745033024021000 | 81491000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 28 | STATEMENT | |
4579 | 31 | 31 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745033630526000 | 745034239455000 | 608929000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 30 | STATEMENT | |
4580 | 73 | 73 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745054935760000 | 745054987405000 | 51645000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 72 | STATEMENT | |
4580 | 75 | 75 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745061942020000 | 745062016612000 | 74592000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 74 | STATEMENT | |
4580 | 77 | 77 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745062599444000 | 745062640931000 | 41487000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 76 | STATEMENT | |
4580 | 79 | 79 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 745063185696000 | 745063226564000 | 40868000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 78 | STATEMENT |
|