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 | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1856903544000 | 1856915242000 | 11698000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1857024888000 | 1857037264000 | 12376000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1857609785000 | 1857620069000 | 10284000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1857763055000 | 1857771871000 | 8816000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1820979896000 | 1822440595000 | 1460699000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1844821723000 | 1844840123000 | 18400000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1845036592000 | 1845104786000 | 68194000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1845210713000 | 1847759031000 | 2548318000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1852408005000 | 1852446948000 | 38943000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1855864963000 | 1855880491000 | 15528000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 422147853580032 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1661865600000 | 1662273507000 | 407907000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
328 | 33 | 33 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23121395131000 | 23122409362000 | 1014231000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 32 | STATEMENT | |
328 | 38 | 38 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23250411299000 | 23250666962000 | 255663000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
328 | 15 | 15 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23097351680000 | 23097539758000 | 188078000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
328 | 17 | 17 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23098129448000 | 23098785288000 | 655840000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 16 | STATEMENT | |
328 | 19 | 19 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23100123837000 | 23100500683000 | 376846000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
328 | 21 | 21 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23101224112000 | 23101378076000 | 153964000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
328 | 25 | 25 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23109864099000 | 23110063838000 | 199739000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 24 | STATEMENT | |
328 | 27 | 27 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23111121980000 | 23111227761000 | 105781000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
328 | 29 | 29 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23111668123000 | 23111803687000 | 135564000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 28 | STATEMENT | |
328 | 31 | 31 | transaction | COMMITTED | 422147853586136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23115706815000 | 23116612703000 | 905888000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 30 | STATEMENT | |
329 | 3 | 3 | transaction | COMMITTED | 422147853582648 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23052265628000 | 23052722594000 | 456966000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT | |
331 | 6 | 6 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23117934550000 | 23118092322000 | 157772000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
331 | 10 | 10 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23134892907000 | 23135149676000 | 256769000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 9 | STATEMENT | |
331 | 12 | 12 | transaction | COMMITTED | 422147853580904 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 23158412010000 | 23159250599000 | 838589000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 11 | STATEMENT |
|