MySQL Storage Engine Comparison Guide

The MySQL Server is unique among database management systems in that it offers the ability to use many different types of database engines via its storage engine architecture. Not only are these engines developed by MySQL/Sun, but a number come from MySQL partners and ISV's as well.  The end result is a very flexible and innovative environment that offers many benefits including higher performance and more efficient usage of hardware resources.

Because the different storage engines have distinct characteristics and use cases where they excel, questions sometimes arise as to which storage engine(s) are best for various types of application scenarios. This paper compares and contrasts in detail all the current internal and external storage engines so MySQL professionals will have a better understanding of the different features of each engine and when to employ the different engines in their database architectures

If you already have a MySQL.com account, save time by logging in now.