MyISAM manages non-transactional tables.
MyISAM is supported in all MySQL configurations, and is the default storage engine.
MEMORY storage engine provides in-memory tables.
MEMORY storage engine was formerly known as the HEAP engine.
MERGE storage engine allows a collection of identical MyISAM tables to be handled as a single table.
MyISAM, the MEMORY and MERGE storage engines handle non-transactional tables, and both are also included in MySQL by default.
InnoDB and BDB storage engines provide transaction-safe tables.
InnoDB is included by default.
EXAMPLE storage engine is a "stub" engine that does nothing.
NDB Cluster is the storage engine used by MySQL Cluster to implement tables that are partitioned over many computers.
ARCHIVE storage engine is used for storing large amounts of data without indexes with a very small footprint.
CSV storage engine stores data in text files using comma-separated values format.
BLACKHOLE storage engine accepts, but does not store data; and retrievals always return an empty set.
FEDERATED storage engine stores data in a remote database.
How do I specify a storage engine to use?
© 2007 John Michael Pierobon