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 | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1842181082000 | 1842193092000 | 12010000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1842329000000 | 1842342467000 | 13467000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1842940824000 | 1842951144000 | 10320000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1843089533000 | 1843098318000 | 8785000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1806402387000 | 1807814881000 | 1412494000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1828290984000 | 1828315390000 | 24406000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1828534082000 | 1828601249000 | 67167000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1828695486000 | 1831058926000 | 2363440000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1837201647000 | 1837260307000 | 58660000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1841222088000 | 1841237634000 | 15546000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421375835244288 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1643433603000 | 1643847175000 | 413572000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
7761 | 6 | 6 | transaction | COMMITTED | 421375835246032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 358305322768000 | 358305363270000 | 40502000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
7761 | 12 | 12 | transaction | COMMITTED | 421375835246032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 358308629409000 | 358308766620000 | 137211000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT | |
7761 | 15 | 15 | transaction | COMMITTED | 421375835246032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 358309857209000 | 358310439954000 | 582745000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
7761 | 19 | 19 | transaction | COMMITTED | 421375835246032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 358311865776000 | 358311981928000 | 116152000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
7761 | 21 | 21 | transaction | COMMITTED | 421375835246032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 358312453026000 | 358312914696000 | 461670000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
7761 | 23 | 23 | transaction | COMMITTED | 421375835246032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 358313525581000 | 358313758057000 | 232476000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
7761 | 26 | 26 | transaction | COMMITTED | 421375835246032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 358321268213000 | 358322128149000 | 859936000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
7763 | 6 | 6 | transaction | COMMITTED | 421375835245160 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 358341466621000 | 358341511277000 | 44656000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|