B.2.1: Where can I obtain complete documentation for MySQL storage engines and the pluggable storage engine architecture?
B.2.2: Are there any new storage engines in MySQL 5.1?
B.2.3: Have any storage engines been removed in MySQL 5.1?
What are the unique benefits of the
B.2.5: Do the new features in MySQL 5.1 apply to all storage engines?
Questions and Answers
See Chapter 14, Storage Engines. That chapter contains
information about all MySQL storage engines except for the
NDB storage engine used for MySQL
NDB is covered in
Chapter 17, MySQL Cluster NDB 6.1 - 7.1.
InnoDB Plugin is available as an
alternative to the built-in version of the
InnoDB storage engine. It includes a
number of features such as the Barracuda file format, table
compression, and new configuration options for performance.
See InnoDB Plugin 1.0 for MySQL 5.1 User’s Guide for details. As you
upgrade to MySQL 5.5 and higher, these features become core
features of the MySQL server, and
becomes the default storage engine for new tables.
There have been significant improvements in existing storage
engines, in particular for the
NDB storage engine that forms
the basis for MySQL Cluster.
IBMDB2I storage engine is
included in the IBM i5/OS (TAR packages) and IBM i5/OS (SAVF
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
Section 14.12, “The
ARCHIVE Storage Engine”, for details.
The general new features such as views, stored procedures,
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.