Feature | MyISAM | NDB | Archive | InnoDB | Memory |
Storage Limits | No | Yes | No | 64TB | Yes |
Transactions | No | Yes | No | Yes | No |
Locking granularity | Table | Row | Row | Row | Table |
MVCC snapshot read | No | No | No | Yes | No |
Geospatial support | Yes | No | Yes | Yes | No |
Data caches | No | Yes | No | Yes | NA |
Index Caches | Yes | Yes | No | Yes | NA |
Compressed Data | Yes | No | Yes | No | No |
Storage cost (relative to other engines) | Small | Med | Small | Med | NA |
Memory cost (relative to other engines) | Low | High | Low | High | High |
Bulk insert speed | High | High | Highest | Med | High |
Replication Support | Yes | Yes | Yes | Yes | Yes |
Foreign Key support | No | No | No | Yes | No |
Built-in Cluster/High-availability support | No | Yes | No | No | No |
Mysql存储引擎特性比较
原创
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
下表列出了Mysql 主要数据引擎架构(如myisam、innodb Storage Engine )的特性比较:
Dynamically add and remove storage engines.
Change the storage engine on a table with “ALTER TABLE …”
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
MYSQL系列:各存储引擎比较
存储引擎是MySQL体系结构的核心。
存储引擎 体系结构 mysql 其他