解讀MySQL的InnoDB引擎日志工作原理

LOG BUFFER           DATA BUFFER

=================    ===============

= Log Record #1 =    = Page Header =

= Log Record #2 =    = Data Row    =

= Log Record #3 =    = Data Row    =

= Log Record #4 =    = Data Row    =

1.         2.         LSN 

<b>Overflows</b><b>Overflow1.         LOG FILE(S) BEFORE WRITING LOG RECORD #5</b>

=================

= Log Record #1 =

= Log Record #2 =

= Log Record #3 =

= Log Record #4 =

LOG FILE(S) AFTER WRITING LOG RECORD #5

= Log Record #5 =

logs

2.          

<b>CheckPoints</b><b> </b>

<b>Recovery</b>

本文轉自holy2009 51CTO部落格，原文連結:http://blog.51cto.com/holy2010/370157