1 InnoDB (not verbose)
Archive supports high concurrent inserts and dedicated buffered row-level locks
Blackhole can be used to copy data to a repository, or to log. Do not save any
CSV does not support indexing, it is easy to structure CSV use
Federated connecting to other MySQL agents
Memory
Usage Scenarios
For finding or mapping tables
Save intermediate data in data analysis
Results for caching of periodic aggregated data
NDB Cluster engine
An improved version of XtraDB InnoDB, the main improvement is performance scalability and operational flexibility
The PBXT supports the engine-level replication foreign key constraints, and provides the appropriate support for solid state storage SSDs with a complex architecture optimized for blobs. MARIADB also contains this engine
Infobright is a column-oriented storage engine. is designed for data analysis and data warehousing. Data is compressed, sorted by block, and each bucket should have a set of data.
MyISAM
compression, full-text indexing, GIS spatial functions
Transaction and row-level locks are not supported and cannot be fully recovered
Data files (MYD) and index files (MYI)
This article is from the "GUI Floral" blog, please be sure to keep this source http://1074963.blog.51cto.com/1064963/1747312
MySQL-supported storage engine (minimalist version)