Major storage Engine details: innodb,tokudb, Memory, MYISAM, Federated

Mainstream storage Engine:

　　INNODB: Recommended use, main engine, using more than 99% of the scene

　　TOKUDB: High-speed write use, the daily amount of large write eg:500g can be compressed to 50G. It is applicable to the write of access log, relative MyISAM has transactional, and has good compressibility relative to InnoDB.

　　INFORBBRIGHT/INFINIDB,OLAP environment: Inferior storage engine, mainly used in OLAP scene, INFINIDB Community Edition can support formation calculation.

Memory: Used as needed, fast, not supported concurrency

Federated: An engine used across the network (not activated by default)

Ndbcluster:mysql the cluster engine, you can store the specified table on disk.

MYISAM: It is recommended to discard and do not support transactions. Memory can only be used up to 4G, single core, one CPU

Major storage Engine details: innodb,tokudb, Memory, MYISAM, Federated