0 
start transaction;
update users set age = 34 where user_id = 3 // update age from 30 to 34 years old.
....
....

when I am updating the age of this user, InnDB will write redo log.

  • What's the structure of redo log?

  • Does it contain initial value 30 and final value 34? or just contains new value 34?

Improve this question
3
  • 1
    This tool might give a few clues.
    – danblack
    Commented Jan 23, 2019 at 4:02
  • OK, it is helpful, but did it give you the answer? If so, what is the answer? (Don't leave other readers hanging!)
    – Rick James
    Commented Jan 23, 2019 at 17:45
  • I just tried this tool, it doesn't work for me. An error is raised. innodb_log -f /usr/local/var/mysql/ib_logfile0 -f /usr/local/var/mysql/ib_logfile1 log-follow-tail-summary
    – Ryan Lyu
    Commented Jan 24, 2019 at 0:49

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.