Mysql存储引擎比较

StorageEngines Feature Summary

Feature	MyISAM	Memory	InnoDB	Archive	NDB
Storagelimits	256TB	RAM	64TB	None	384EB
Transactions	No	No	Yes	No	Yes
Lockinggranularity	Table	Table	Row	Table	Row
MVCC	No	No	Yes	No	No
Geospatialdata type support	Yes	No	Yes	Yes	Yes
Geospatialindexing support	Yes	No	Yes[a]	No	No
B-treeindexes	Yes	Yes	Yes	No	No
T-treeindexes	No	No	No	No	Yes
Hashindexes	No	Yes	No[b]	No	Yes
Full-textsearch indexes	Yes	No	Yes[c]	No	No
Clusteredindexes	No	No	Yes	No	No
Datacaches	No	N/A	Yes	No	Yes
Indexcaches	Yes	N/A	Yes	No	Yes
Compresseddata	Yes[d]	No	Yes[e]	Yes	No
Encrypteddata[f]	Yes	Yes	Yes	Yes	Yes
Clusterdatabase support	No	No	No	No	Yes
Replicationsupport[g]	Yes	Yes	Yes	Yes	Yes
Foreignkey support	No	No	Yes	No	No
Backup/ point-in-time recovery[h]	Yes	Yes	Yes	Yes	Yes
Querycache support	Yes	Yes	Yes	Yes	Yes
Updatestatistics for data dictionary	Yes	Yes	Yes	Yes	Yes
[a]InnoDB support for geospatial indexing is available in MySQL5.7.5 and higher. [b]InnoDB utilizes hash indexes internally for its AdaptiveHash Index feature. [c]InnoDB support for FULLTEXT indexes is available in MySQL5.6.4 and higher. [d]Compressed MyISAM tables are supported only when using thecompressed row format. Tables using the compressed row formatwith MyISAM are read only. [e]Compressed InnoDB tables require the InnoDB Barracuda fileformat. [f]Implemented in the server (via encryption functions), ratherthan in the storage engine. [g]Implemented in the server, rather than in the storageengine. [h]Implemented in the server, rather than in the storageengine.