Related Documentation Download this Manual
PDF (US Ltr) - 31.2Mb
PDF (A4) - 31.2Mb
PDF (RPM) - 30.4Mb
EPUB - 7.7Mb
HTML Download (TGZ) - 7.5Mb
HTML Download (Zip) - 7.6Mb
HTML Download (RPM) - 6.5Mb
Eclipse Doc Plugin (TGZ) - 8.3Mb
Eclipse Doc Plugin (Zip) - 10.1Mb
Man Pages (TGZ) - 183.8Kb
Man Pages (Zip) - 295.2Kb
Info (Gzip) - 2.9Mb
Info (Zip) - 2.9Mb
Excerpts from this Manual

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

A.2 MySQL 5.6 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.6?
A.2.3. Have any storage engines been removed in MySQL 5.6?
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.3 and NDB Cluster 7.4.

A.2.2.

Are there any new storage engines in MySQL 5.6?

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. See Chapter 14, The InnoDB Storage Engine for details. 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.6?

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.5, “The ARCHIVE Storage Engine”, for details.


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