存储引擎

Submitted by yejr on 周四, 2006/11/16 - 16:49

A.2. MySQL 5.0 FAQ — 存储引擎

Questions

  • 26.2.1: 我在哪里可以找到完整的MySQL存储引擎文档呢?

    Where can I obtain complete documentation for MySQL storage engines?

  • 26.2.2: MySQL 5.0中是否有新的存储引擎呢?

    Are there any new storage engines in MySQL 5.0?

  • 26.2.3: MySQL 5.0中是否去掉什么存储引擎了?

    Have any storage engines been removed in MySQL 5.0?

  • 26.2.4: ARCHIVE 存储引擎唯一的好处是什么呢?

    What are the unique benefits of the ARCHIVE storage engine?

  • 26.2.5: MySQL 5.0中所有的存储引擎是否有新功能呢?

    Do the new features in MySQL 5.0 apply to all storage engines?

Questions and Answers

26.2.1:
Where can I obtain complete documentation for MySQL storage
engines?

详情请看 Chapter 14, Storage Engines and
Table Types 和关于MySQL Cluster的 NDB 存储引擎 Chapter 15, MySQL Cluster .

See Chapter 14, Storage Engines and Table Types. That chapter contains
information about all MySQL storage engines except for the
NDB storage engine used for MySQL
Cluster; NDB is covered in
Chapter 15, MySQL Cluster.

26.2.2:
Are there any new storage engines in MySQL 5.0?

是的.MySQL 5.0中新增了 FEDERATED 存储引擎,它支持访问远程服务器上的数据表.详情请看 Section 14.7, “The FEDERATED Storage Engine”.

Yes. The FEDERATED storage engine, new in
MySQL 5.0, allows the server to access tables
on other (remote) servers. See
Section 14.7, “The FEDERATED Storage Engine”.

26.2.3:
Have any storage engines been removed in MySQL
5.0?

是的.MySQL 5.0不再支持 ISAM 存储引擎了.如果你以前版本的MySQL中还存在 ISAM 表的话,那么在升级到5.0之前要先转成 MyISAM 类型表.

Yes. MySQL 5.0 no longer supports the
ISAM storage engine. If you have any
existing ISAM tables from previous
versions of MySQL, you should convert these to
MyISAM before upgrading to MySQL
5.0.

26.2.4:
What are the unique benefits of the
ARCHIVE storage engine?

ARCHIVE 存储引擎适合存储那些大量的没有索引的数据;它占用很少的空间,查询的时候执行的是全表扫描. 详情请看 See Section 14.8, “The ARCHIVE Storage Engine”.

The ARCHIVE storage engine is ideally
suited for storing large amounts of data without indexes; it
has a very small footprint, and performs selects using table
scans. See Section 14.8, “The ARCHIVE Storage Engine”, for
details.

26.2.5:
Do the new features in MySQL 5.0 apply to all
storage engines?

所有的存储引擎都支持一些新的功能,如视图,存储过程,触发器INFORMATION_SCHEMA,精确数学类型(DECIMAL),BIT 类型.一些特定的存储引擎还有其他更新.

The general new features such as views, stored procedures,
triggers, INFORMATION_SCHEMA, precision
math (DECIMAL column type), and the
BIT column type, apply to all storage
engines. There are also additions and changes for specific
storage engines.

技术相关: