Linux MySQL Storage Engine detailed

MySQL commonly used storage engine is myisam, InnoDB, memory, MERGE , Where InnoDB provides a transaction security table, the other storage engines are non-transactional security tables. &NBSP

myisam is the default storage engine for MySQL. myisam does not support transactions, and foreign keys are not supported, but their access is fast and there is no requirement for transactional integrity. &NBSP

innodb storage Engine provides transactional security with commit, rollback, and crash resiliency. But compared to myisam storage engine, innodb Write processing is less efficient and consumes more disk space to preserve data and indexes. &NBSP

memory storage engine uses content that exists in memory to create a table. Each memory table only actually corresponds to one disk file. memory type of table access is very fast because its data is in memory and the hash index is used by default. But once the service is closed, the data in the table is lost. &NBSP

merge storage Engine is a set of myisam table combination , these MyISAM tables must be structurally identical. merge the table itself has no data, for merge type of table for query, update, delete operations Is the myisam of the internal table.  

Linux MySQL Storage Engine detailed