InnoDB

InnoDB operates by following the ACID model which has transaction features such as commit, rollback, and has crash recovery capabilities for user data protection. It utilizes row level locking to increase multi-user concurrency and performance. InnoDB stores user data in clustered indexes to reduce I/O for common queries based on primary keys.  InnoDB has Foreign Key support for maintaining data integrity.