First I want to thank everyone who attended my December 19, 2019 webinar “Top 3 Features of MySQL“. Recording and slides are available on the webinar page.
Here are answers to the questions from participants which I was not able to provide during the webinar.
Q: When do undo logs and redo logs come into play? Can you please explain the background operations of these logs?
A: These two are completely different structures.
Undo Logs
Belong to a single active transaction. It contains information on how to undo the latest change to the clustered index, performed by this transaction.
Let’s demonstrate how they work with an example.
Consider this table:
…[Read more]