Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain another important mechanism that affects both response time and throughput – The transaction log. The InnoDB transaction log handles REDO logging, this is the mechanism that provides the A (Atomic) C (Consistent)Â and D (Durability) in ACID. The transaction log keeps a complete record o
