Table of Contents [+/-]
MyISAM Storage Engine [+/-]Maria Storage Engine [+/-]InnoDB Storage Engine [+/-]InnoDB OverviewInnoDB Contact InformationInnoDB ConfigurationInnoDB Startup Options and System VariablesInnoDB TablespaceInnoDB TablesInnoDB Data and Log FilesInnoDB DatabaseInnoDB Database to Another MachineInnoDB Transaction Model and LockingInnoDB Performance Tuning TipsInnoDB Table and Index StructuresInnoDB File Space Management and Disk I/OInnoDB Error HandlingInnoDB TablesInnoDB TroubleshootingMERGE Storage Engine [+/-]MEMORY (HEAP) Storage EngineEXAMPLE Storage EngineFEDERATED Storage Engine [+/-]ARCHIVE Storage EngineCSV Storage Engine [+/-]BLACKHOLE Storage EngineMySQL supports several storage engines that act as handlers for different table types. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables.
With MySQL 5.1, MySQL AB has introduced a new pluggable storage engine architecture that allows storage engines to be loaded into and unloaded from a running MySQL server.
This chapter describes each of the MySQL storage engines except for
NDBCLUSTER, which is covered in
MySQL Cluster. It also contains a description of
the pluggable storage engine architecture (see
Section 13.1, “Overview of MySQL Storage Engine Architecture”).
For answers to some commonly asked questions about MySQL storage engines, see Section A.2, “MySQL 5.1 FAQ — Storage Engines”.

User Comments
I have tried setting the storage engine or table type in my.cnf as well as in the command line. These appear to be unknown variables in 4.1.7. This is on a Mac OS X 10.3.5 machine.
To set the default engine use this in the my.cnf file: default-table-type=NDBCLUSTER
From the command line use: --default-table-type=NDBCLUSTER
I've tried setting up the default storage engine in the configuration, and if I use:
table_type = innodb
or
storage_engine = innodb
mysqld would fail to restart. I've now used:
default-storage_engine = innodb
And it works. See also http://bugs.mysql.com/bug.php?id=19061
More information about how to pick the best MySQL Storage engine for your real life scenario:
http://www.softwareprojects.com/resources/programming/t-mysql-storage-engines-1470.html
Add your own comment.