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 | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1461782698000 | 1461790046000 | 7348000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1461857340000 | 1461865386000 | 8046000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1462244003000 | 1462250417000 | 6414000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1462343194000 | 1462349185000 | 5991000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1447207773000 | 1447877233000 | 669460000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1455216344000 | 1455223955000 | 7611000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1455297097000 | 1455324491000 | 27394000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1455354578000 | 1456009789000 | 655211000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1458566925000 | 1458586594000 | 19669000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1461103272000 | 1461112650000 | 9378000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421384529393408 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1315416625000 | 1315637586000 | 220961000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
5561 | 6 | 6 | transaction | COMMITTED | 421384529394280 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 852195446327000 | 852195490887000 | 44560000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|