---

How to check MySQL storage engine type on Linux

There are two major MySQL storage engines used: MyISAM and Innodb. MyISAM is non-transactional, and thus can be faster for reads, while InnoDB fully supports transactions (e.g., commit/rollback) with finer-grain locking. When you create a new MySQL table, you choose its type (i.e., storage engine). Without any choice, you will simply use a pre-configured default engine.

Get the Free Newsletter!

Subscribe to Developer Insider for top news, trends, & analysis