Mysql存储引擎特性比较

下表列出了Mysql 主要数据引擎架构(如myisam、innodb Storage Engine )的特性比较:

 

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

 

Dynamically add and remove storage engines.
Change the storage engine on a table with “ALTER TABLE …”

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569