How to check MySQL storage engine type on Linux

Posted by xmodulo on Jun 28, 2014 2:38 PM EDT
Xmodulo
Mail this story
Print this story

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.

Full Story

  Nav
» Read more about: Story Type: Tutorial; Groups: Linux, MySQL

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.