MySQL 5.0 Certification Study Guide

MySQL allows you to choose from any of several storage engines when creating a table. Different table types are managed by different storage engines, each of which has specific characteristics. This chapter discusses the features of several storage engines in detail and summarizes others. It covers the following exam topics:

• An overview of the storage engine concept in MySQL

• The MyISAM storage engine

• The MERGE storage engine

• The InnoDB storage engine

• The MEMORY storage engine

• The FEDERATED storage engine

• The Cluster storage engine

• A summary of other storage engines