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. |