MySQL™: The World’s Most Popular Open Source Database 184 InnoDB Redo Log Structure • A collection of log records PageNo Offset Record Type Changes on that page • Page Number (4 bytes, page within Tablespace) • Offset of the change within the page (2 bytes) • Log Record Type (1 byte) – Insert, Update, Delete – Other types (like ”fill space with blanks”) • Changes (only redo values, no old values) except for DELETEs, which need no change notes at all Copyright 2003 MySQL AB