Linux Today: Linux News On Internet Time.





More on LinuxToday


How to check MySQL storage engine type on Linux

Jul 01, 2014, 23:00 (0 Talkback[s])
(Other stories by Xmodulo)

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.

Complete Story