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 | |
3742 | 7 | 7 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651602305580000 | 651602359637000 | 54057000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 6 | STATEMENT | |
3742 | 9 | 9 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651602750013000 | 651602786629000 | 36616000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT | |
3742 | 11 | 11 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651604165495000 | 651604680597000 | 515102000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
3742 | 13 | 13 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651605672967000 | 651606123504000 | 450537000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 12 | STATEMENT | |
3742 | 16 | 16 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651610385770000 | 651610871232000 | 485462000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 15 | STATEMENT | |
3742 | 22 | 22 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651637309182000 | 651637507386000 | 198204000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 21 | STATEMENT | |
3742 | 24 | 24 | transaction | COMMITTED | 422023192772920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651641675771000 | 651642255674000 | 579903000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
3743 | 3 | 3 | transaction | COMMITTED | 422023192771176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651553667791000 | 651554586039000 | 918248000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
3745 | 8 | 8 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651568612060000 | 651571075671000 | 2463611000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7 | STATEMENT | |
3745 | 10 | 10 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651573454859000 | 651574009405000 | 554546000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 9 | STATEMENT | |
3745 | 13 | 13 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651577066845000 | 651577493869000 | 427024000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 12 | STATEMENT | |
3745 | 17 | 17 | transaction | COMMITTED | 422023192772048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651634057437000 | 651634270804000 | 213367000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
3747 | 6 | 6 | transaction | COMMITTED | 422023192773792 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651634313062000 | 651634340445000 | 27383000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|