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 | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1845815701000 | 1845830260000 | 14559000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1845970259000 | 1845985429000 | 15170000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1846714599000 | 1846727176000 | 12577000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1846899526000 | 1846908963000 | 9437000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1812759298000 | 1813913777000 | 1154479000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1831724063000 | 1831748801000 | 24738000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1831941980000 | 1832046875000 | 104895000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1832154233000 | 1834372687000 | 2218454000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1840339390000 | 1840402692000 | 63302000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1844668340000 | 1844693623000 | 25283000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1542 | 7 | 7 | transaction | COMMITTED | 421626673643832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193279581844000 | 193279602123000 | 20279000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 6 | STATEMENT | |
1542 | 9 | 9 | transaction | COMMITTED | 421626673643832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193279919900000 | 193279991682000 | 71782000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT | |
1542 | 11 | 11 | transaction | COMMITTED | 421626673643832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193280527989000 | 193281171393000 | 643404000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
1542 | 13 | 13 | transaction | COMMITTED | 421626673643832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193281669516000 | 193281894383000 | 224867000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 12 | STATEMENT | |
1542 | 16 | 16 | transaction | COMMITTED | 421626673643832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193282825846000 | 193283474903000 | 649057000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 15 | STATEMENT | |
1542 | 22 | 22 | transaction | COMMITTED | 421626673643832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193326404428000 | 193326727371000 | 322943000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 21 | STATEMENT | |
1542 | 24 | 24 | transaction | COMMITTED | 421626673643832 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193331006276000 | 193332017707000 | 1011431000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 23 | STATEMENT | |
35 | 1 | 1 | transaction | COMMITTED | 421626673641216 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1660426485000 | 1660642827000 | 216342000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1544 | 3 | 3 | transaction | COMMITTED | 421626673642088 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193242174206000 | 193243598165000 | 1423959000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
1545 | 33 | 33 | transaction | COMMITTED | 421626673642960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193294791869000 | 193295386228000 | 594359000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
1545 | 11 | 11 | transaction | COMMITTED | 421626673642960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193276690593000 | 193276791705000 | 101112000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
1545 | 15 | 15 | transaction | COMMITTED | 421626673642960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193278210989000 | 193278362483000 | 151494000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
1545 | 17 | 17 | transaction | COMMITTED | 421626673642960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193278968846000 | 193279505577000 | 536731000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
1545 | 19 | 19 | transaction | COMMITTED | 421626673642960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193281331673000 | 193282107100000 | 775427000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
1545 | 21 | 21 | transaction | COMMITTED | 421626673642960 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 193283683701000 | 193283808464000 | 124763000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT |
|