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 | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1524079204000 | 1524086846000 | 7642000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1524167975000 | 1524178016000 | 10041000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1524720392000 | 1524727892000 | 7500000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1524833251000 | 1524839916000 | 6665000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1509458557000 | 1510148533000 | 689976000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1517309737000 | 1517318226000 | 8489000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1517397899000 | 1517430233000 | 32334000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1517469976000 | 1517819987000 | 350011000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1520831804000 | 1520855777000 | 23973000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1523303084000 | 1523315094000 | 12010000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422003693168384 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1365585873000 | 1365861616000 | 275743000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1375 | 8 | 8 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142046425532000 | 142046528150000 | 102618000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 7 | STATEMENT | |
1375 | 11 | 11 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142048759892000 | 142049754929000 | 995037000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
1375 | 13 | 13 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142050899399000 | 142051402151000 | 502752000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 12 | STATEMENT | |
1375 | 15 | 15 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142052427875000 | 142052556226000 | 128351000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
1375 | 17 | 17 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142053498136000 | 142053626799000 | 128663000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
1375 | 19 | 19 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142055769117000 | 142056957413000 | 1188296000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
1375 | 21 | 21 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142133074665000 | 142133372343000 | 297678000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
1375 | 23 | 23 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142133768725000 | 142133864557000 | 95832000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
1375 | 25 | 25 | transaction | COMMITTED | 422003693169256 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142134216885000 | 142134299999000 | 83114000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 24 | STATEMENT | |
1377 | 6 | 6 | transaction | COMMITTED | 422003693171000 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142132480744000 | 142132536720000 | 55976000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
1378 | 6 | 6 | transaction | COMMITTED | 422003693171872 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142135393782000 | 142135422052000 | 28270000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
1379 | 3 | 3 | transaction | COMMITTED | 422003693170128 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 142113790913000 | 142114139597000 | 348684000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT |
|