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 | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1836462860000 | 1836472198000 | 9338000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1836575352000 | 1836585966000 | 10614000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1837043236000 | 1837051035000 | 7799000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1837174825000 | 1837182496000 | 7671000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1806936522000 | 1808357809000 | 1421287000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1825787451000 | 1825801344000 | 13893000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1825971675000 | 1826044800000 | 73125000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1826139835000 | 1827347505000 | 1207670000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1831201629000 | 1831246348000 | 44719000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421943307471464 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1834781480000 | 1834798110000 | 16630000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421943307470592 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1656599155000 | 1656865938000 | 266783000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
7045 | 6 | 6 | transaction | COMMITTED | 421943307473208 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472854406453000 | 472854461210000 | 54757000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
7045 | 12 | 12 | transaction | COMMITTED | 421943307473208 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472866515473000 | 472866657837000 | 142364000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
7045 | 15 | 15 | transaction | COMMITTED | 421943307473208 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472867528221000 | 472868125136000 | 596915000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
7045 | 19 | 19 | transaction | COMMITTED | 421943307473208 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472869369101000 | 472869525419000 | 156318000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
7045 | 21 | 21 | transaction | COMMITTED | 421943307473208 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472870026058000 | 472870496585000 | 470527000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
7045 | 23 | 23 | transaction | COMMITTED | 421943307473208 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472871080184000 | 472871331530000 | 251346000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
7045 | 26 | 26 | transaction | COMMITTED | 421943307473208 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472882795288000 | 472883675637000 | 880349000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
7047 | 6 | 6 | transaction | COMMITTED | 421943307474080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472878383656000 | 472878427438000 | 43782000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
7047 | 12 | 12 | transaction | COMMITTED | 421943307474080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472888831294000 | 472889020006000 | 188712000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
7047 | 15 | 15 | transaction | COMMITTED | 421943307474080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472890040331000 | 472890685494000 | 645163000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
7047 | 19 | 19 | transaction | COMMITTED | 421943307474080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472891919659000 | 472892103982000 | 184323000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
7047 | 21 | 21 | transaction | COMMITTED | 421943307474080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472892565891000 | 472892922964000 | 357073000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
7047 | 23 | 23 | transaction | COMMITTED | 421943307474080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472893608651000 | 472893968537000 | 359886000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
7047 | 27 | 27 | transaction | COMMITTED | 421943307474080 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 472899073377000 | 472899881783000 | 808406000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT |
|