MyISAM - Default database engine. Table-Level locking mechanism. Doesn't support transactions. consume less disk space. speedy read operations,so popular for Web development
InnoDB - Row level locking mechanism. Transaction-safe (commit, rollback, and crash recovery capabilities). consume more disk space. Slower than the MyISAM engines.
ISAM - ISAM performs very fast read operations. Doesn't support transactions. If your hard drive crashes, the data files will not be recovered.
Memory (Heap) - HEAP allows for temporary tables that reside only in memory. Residing in memory makes HEAP faster than ISAM or MyISAM. Its volatile and will be lost if it's not saved prior to shutdown.
Archive - Stores very large volumes of infrequently-or-never updated information
Merge - The MERGE engine type allows you to combine a number of identical tables into a single table.
Federated - Accesses data in tables of remote databases. No data is stored on the local tables
NDB Cluster - For distributed computing environment(running several MySQL servers in a cluster).
CSV - Data from any CSV engine file can easily be imported into any standard spreadsheet.
BDB (Berkeley DB) - Each BDB table is stored on disk in two files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table format, and a .db file contains the table data and indexes. To support transaction rollback, the BDB storage engine maintains log files
