MySQL Engine Types

ISAM:   
It is old version of MyISAM which is deprecated. This is original mySQL engine.


MyISAM:
This is non-transactional storage engine which provides full-text indeding. It is default for mysql.

MERGE:
This is a non-transactional storage engine which allows a collection of MYISAM tables with identical column and index information as one.

MEMORY (HEAP): 
This engine stores data in memory. It is a non-transactional storage engine.

BDB (Berkeley DB):
This is first transactional-safe storage engine.   

InnoDB:
This is a transactional-safe, row-level locking storage engine. This engine is designed for maximum performance for large volume of data.   

FEDERATED:
This engine accesses data in tables of remote databases rather than in local tables.

ARCHIVE:
This engine stores large amount of data without indexes.   

CSV:
This engine stores data in text file using comma-separated-values format.

BLACKHOLE: 
This engine acts as black-hole which accepts data and throws it away and doesn't store.

EXAMPLE:
A stub engine which serve as an example that illustrates how to begin writing new engines.