mysql存储过程:如何选择合适的MySQL存储引擎来源: 发布时间:星期二, 2009年2月10日 浏览:53次 评论:0
="t18">本文将讲述MySQL中多种存储引擎
![]() ![]() ![]() MySQL有多种存储引擎: MyISAM、InnoDB、MERGE、MEMORY(HEAP)、BDB(BerkeleyDB)、EXAMPLE、FEDERATED、ARCHIVE、CSV、BLACKHOLE ![]() MySQL支持数个存储引擎作为对区别表 ![]() ![]() ![]() ![]() ![]() ◆ MyISAM管理非事务表 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ◆ MEMORY存储引擎提供“内存中”表 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 注释:MEMORY存储引擎正式地被确定为HEAP引擎 ![]() ◆ InnoDB和BDB存储引擎提供事务安全表 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ◆ EXAMPLE存储引擎是 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ◆ NDB Cluster是被MySQL Cluster用来实现分割到多台计算机上 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ◆ ARCHIVE存储引擎被用来无索引地 ![]() ![]() ![]() ◆ CSV存储引擎把数据以逗号分隔 ![]() ![]() ◆ BLACKHOLE存储引擎接受但不存储数据 ![]() ![]() ![]() ◆ FEDERATED存储引擎把数据存在远程数据库中 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 当你创建 ![]() ![]() ![]() ![]() ![]() CREATE TABLE t (i INT) ENGINE = INNODB; CREATE TABLE t (i INT) TYPE = MEMORY; 虽然TYPE仍然在MySQL 5.1中被支持 ![]() ![]() ![]() 如何选择最适合你 ![]() 下述存储引擎是最常用 ![]() ◆ MyISAM:默认 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ◆ InnoDB:用于事务处理应用 ![]() ![]() ![]() ![]() ◆ BDB:可替代InnoDB ![]() ![]() ![]() ◆ Memory:将所有数据保存在RAM中 ![]() ![]() ![]() ![]() ![]() ◆ Merge:允许MySQL DBA或开发人员将 ![]() ![]() ![]() ![]() ![]() ![]() ◆ Archive:为大量很少引用 ![]() ![]() ![]() ![]() ◆ Federated:能够将多个分离 ![]() ![]() ![]() ![]() ![]() ◆ Cluster/NDB:MySQL ![]() ![]() ![]() ![]() ![]() ![]() ![]() ◆ Other:其他存储引擎包括CSV(引用由逗号隔开 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 请记住 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() mysql> show engines; +------------+---------+----------------------------------------------------------------+ | Engine | Support | Comment | +------------+---------+----------------------------------------------------------------+ | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | | BerkeleyDB | NO | Supports transactions and page-level locking | | BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) | | EXAMPLE | NO | Example storage engine | | ARCHIVE | NO | Archive storage engine | | CSV | NO | CSV storage engine | | ndbcluster | NO | Clustered, fault-tolerant, memory-based tables | | FEDERATED | NO | Federated MySQL storage engine | | MRG_MYISAM | YES | Collection of identical MyISAM tables | | ISAM | NO | Obsolete storage engine | +------------+---------+----------------------------------------------------------------+ 0
相关文章
读者评论发表评论 |