How to check MySQL storage engine type on Linux
Jul 01, 2014, 23:00 (0 Talkback[s])
(Other stories by Xmodulo)
Full Text Search: The Key to Better Natural Language Queries for NoSQL in Node.js
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.