Answer
InnoDB manages transactions using undo logs, redo logs, and a buffer pool. It maintains ACID compliance through MVCC, row-level locking, and transaction logs that support rollbacks and crash recovery.
Quick Answer
InnoDB transactions: each transaction writes changes to the redo log (on disk) before data pages are modified (write-ahead logging). Uncommitted data pages modified in the buffer pool. On COMMIT: redo log flushed to disk, transaction committed. On ROLLBACK: undo log reverses changes. MVCC allows concurrent reads of consistent snapshots without blocking writers or readers.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ