Source code editor
What Is Ajax
26.2.1: Where can I obtain complete documentation for MySQL storage engines?
26.2.2: Are there any new storage engines in MySQL 5.0?
26.2.3: Have any storage engines been removed in MySQL 5.0?
What are the unique benefits of the
ARCHIVE storage engine?
26.2.5: Do the new features in MySQL 5.0 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 15, MySQL Cluster.
FEDERATED storage engine, new in
MySQL 5.0, allows the server to access tables
on other (remote) servers. See
Section 14.7, “The
FEDERATED Storage Engine”.
Yes. MySQL 5.0 no longer supports the
ISAM storage engine. If you have any
ISAM tables from previous
versions of MySQL, you should convert these to
MyISAM before upgrading to MySQL
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.8, “The
ARCHIVE Storage Engine”, 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
Source code editor What Is Ajax