Questions
26.2.1: Where can I obtain complete documentation for MySQL storage engines and the pluggable storage engine architecture?
26.2.2: Are there any new storage engines in MySQL 5.1?
26.2.3: Have any storage engines been removed in MySQL 5.1?
26.2.4:
What are the unique benefits of the
ARCHIVE
storage engine?
26.2.5: Do the new features in MySQL 5.1 apply to all storage engines?
Questions and Answers
26.2.1: Where can I obtain complete documentation for MySQL storage engines and the pluggable storage engine architecture?
See 章 13. ストレージエンジンとテーブルタイプ. That chapter contains
information about all MySQL storage engines except for the
NDB
storage engine used for MySQL
Cluster; NDB
is covered in
章 14. MySQL Cluster.
26.2.2: Are there any new storage engines in MySQL 5.1?
MySQL 5.1 introduces an alpha version of the new Falcon storage engine.
Falconのサポートは、MySQL5.1の標準リリースではできません。FalconはMySQL 5.1の開発から特別に分岐したリリースにおいてのみ可能です。情報はここで評価のみの目的として供給されます。
For information about the Falcon storage engine, see The Falcon Storage Engine.
There have also been significant improvements in existing
storage engines, in particular for the
NDB
storage engine that forms the basis
for MySQL Cluster.
26.2.3: Have any storage engines been removed in MySQL 5.1?
Yes. MySQL 5.1 no longer supports the
BDB
storage engine. Any existing
BDB
tables should be converted to another
storage engine before upgrading to MySQL 5.1.
26.2.4:
What are the unique benefits of 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 項13.10. 「ARCHIVE
ストレージエンジン」, for
details.
26.2.5: Do the new features in MySQL 5.1 apply to all storage engines?
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.