I want to know if a certain transaction got rolled back. If we analyze
SHOW ENGINE INNODB STATUS\G;
we get the list rolled back transactions with transactionid , but how to get the actual query from this
eg I have
*** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 89504501 Purge done for trx's n:o < 88503595 undo n:o < 0 state: running but idle History list length 2341 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 531230733218221, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 531230733221873, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 531230733213665, not started 0 lock struct(s), heap size 1136, 0 row lock(s)
I get some transcation id = 531230733218221, but what is the INSERT/UPDATE query corresponding to this. Here is my mysql config:
Version: 5.7 Binary Log: ON Slow Query Log: ON General Query Log: OFF Performance Schema: ON Profiling: OFF Transaction Isolation Level: REPEATABLE-READ
Is there any table in performance_schema that we can explore. Since MySQL do not have any mechanism to store the last updated timestamp at row/column level, though it exists at the table level.