Want to save your progress?
Create a free account to track your lessons and quizzes across devices.
Register Login
« Back to ClassCompleted: 50%

The Web Standards - MySQL & MariaDB

Page 2 of 2

Storage Engines: InnoDB vs. MyISAM

One of the unique features of the MySQL architecture is its Pluggable Storage Engine model. This allows you to choose how data is stored and retrieved on a table-by-table basis.

  • InnoDB: This is the default and recommended engine for modern applications. It supports Transactions (ACID compliance), Foreign Keys, and row-level locking. A DBA should almost always ensure tables are using InnoDB.

  • MyISAM: The older, legacy engine. It is faster for some very specific read-heavy operations but does not support transactions. If the server crashes, MyISAM tables can easily become corrupted.

  • Checking the Engine: SHOW TABLE STATUS FROM database_name;