Related Documentation Download this Manual Excerpts from this Manual

MySQL 5.5 Reference Manual  /  MySQL 5.5 Frequently Asked Questions  /  MySQL 5.5 FAQ: Storage Engines

A.2 MySQL 5.5 FAQ: Storage Engines

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.5?
A.2.3. Have any storage engines been removed in MySQL 5.5?
A.2.4. What are the unique benefits of the ARCHIVE storage engine?

A.2.1.

Where can I obtain complete documentation for MySQL storage engines?

See Chapter 15, Alternative Storage Engines. That chapter contains information about all MySQL storage engines except for the InnoDB storage engine and the NDB storage engine (used for MySQL Cluster). InnoDB is covered in Chapter 14, The InnoDB Storage Engine. NDB is covered in Chapter 18, MySQL NDB Cluster 7.2.

A.2.2.

Are there any new storage engines in MySQL 5.5?

The features from the optional InnoDB Plugin 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. InnoDB also becomes the default storage engine for new tables. See Section 14.1, “Introduction to InnoDB” for details.

A.2.3.

Have any storage engines been removed in MySQL 5.5?

No.

A.2.4.

What are the unique benefits of the ARCHIVE storage engine?

The ARCHIVE storage engine stores large amounts of data without indexes; it has a small footprint, and performs selects using table scans. See Section 15.6, “The ARCHIVE Storage Engine”, for details.


User Comments
Sign Up Login You must be logged in to post a comment.