Questions
B.2.1: Where can I obtain complete documentation for MySQL storage engines?
B.2.2: Are there any new storage engines in MySQL 5.5?
B.2.3: Have any storage engines been removed in MySQL 5.5?
B.2.4: What are the unique benefits of the
ARCHIVEstorage engine?B.2.5: Do the new features in MySQL 5.5 apply to all storage engines?
Questions and Answers
B.2.1: Where can I obtain complete documentation for MySQL storage engines?
See Chapter 13, Storage Engines. That chapter contains
information about all MySQL storage engines except for the
NDB storage engine used for MySQL
Cluster; NDB is covered in
MySQL Cluster NDB 6.X/7.X.
B.2.2: Are there any new storage engines in MySQL 5.5?
No, but the InnoDB Plugin is the built-in
version of the InnoDB storage engine.
B.2.3: Have any storage engines been removed in MySQL 5.5?
No.
B.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
Section 13.12, “The ARCHIVE Storage Engine”, for details.
B.2.5: Do the new features in MySQL 5.5 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.