MySQL Storage engine

The common storage engine for MySQL is MyISAM, InnoDB, memory, MERGE, where InnoDB provides transaction security tables, and other storage engines are non-transactional security tables.

MyISAM is the default storage engine for MySQL. MyISAM does not support transactions or foreign keys, but it has fast access and no requirement for transactional integrity.

The InnoDB storage Engine provides transactional security with commit, rollback, and crash resiliency. However, compared with the MyISAM storage engine, InnoDB writes are less efficient and consume more disk space to preserve data and indexes.

View the storage engine provided by MySQL:

Show engines;

To view the current default storage engine:

 like ' %storage_engine% ';

Change the current presence engine of the table (which can be set directly when creating the table):

Alter table tb_name engine=InnoDB;

Reference: http://menglimengwai.iteye.com/blog/464667

MySQL Storage engine