MySQL™: The World’s Most Popular Open Source Database 180 The InnoDB Storage Engine IN memory On disk (workspace) Log Buffer Log Log File 1 esil (buffered COMMIT o Log File 2 Log f log records) (+ checkpoint) Red Log File 3 ce Buffer pool Undo Log ibdata1 (buffered data file spae data pages) checkpoint l ibdata2 abT data file Add’t’l Mem Pool Copyright 2003 MySQL AB