A.2.1: Where can I obtain complete documentation for MySQL storage engines?
A.2.2: Are there any new storage engines in MySQL 5.6?
A.2.3: Have any storage engines been removed in MySQL 5.6?
What are the unique benefits of the
A.2.5: Do the new features in MySQL 5.6 apply to all storage engines?
Questions and Answers
See Chapter 15, Alternative 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 18, MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4.
The features from the optional
from MySQL 5.1 are folded into the built-in
InnoDB storage engine, so you can take
advantage of features such as the Barracuda file format,
InnoDB table compression, and the new
configuration options for performance. See
Chapter 14, The InnoDB Storage Engine for details.
InnoDB also becomes the default storage
engine for new tables. See Section 14.1.1, “InnoDB as the Default MySQL Storage Engine”
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 15.5, “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.