InnoDB

In MySQL 8, InnoDB is the default storage engine broadly used out of all other available storage engines. InnoDB was released with MySQL 5.1 as a plugin in 2008 and this is considered as default storage engine from the version 5.5 and later. InnoDB has been taken over by Oracle Corporation in October 2005, from the Innobase Oy, which is a Finland-based company.

InnoDB tables support ACID-compliant commits, rollback, and crash recovery capabilities to protect user data. It also supports row-level locking, which helps with better concurrency and performance. InnoDB stores data in clustered indexes to reduce I/O operations for the all SQL select queries based on the primary key. InnoDB also supports FOREIGN KEY constraints that allows better data integrity for the database. The maximum size of an InnoDB table can scale up to 256 TB, which should be good enough to serve many big data use cases.