Storage engines allow you to store data. The right storage engine is chosen according to the use-case at hand, and the customer's needs. If you are running MySQL and want to see which engines are available, you can use the show engines command for guidance. In this section, we are going to cover the basics of a number of storage engines and will learn why Oracle chooses InnoDB as the default storage engine for MySQL 8.0:
mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
|...
