A.2.1: Where can I obtain complete documentation for MySQL storage engines and the pluggable storage engine architecture?
A.2.2: Are there any new storage engines in MySQL 5.1?
A.2.3: Have any storage engines been removed in MySQL 5.1?
What are the unique benefits of the
ARCHIVE storage engine?
A.2.5: Do the new features in MySQL 5.1 apply to all storage engines?
Questions and Answers
There have been significant improvements in existing storage
engines, in particular for the
storage engine that forms the basis for MySQL Cluster.
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.
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 「
ARCHIVE ストレージエンジン」, for
The general new features such as views, stored procedures,
DECIMAL column type), and the
BIT column type, apply to all storage
engines. There are also additions and changes for specific