Table 1-5 lists some of the table types supported in most MySQL installations. For truly atomic database transactions, you should use InnoDB tables.
Type
Transactional
Description
BDB
Yes
Transaction-safe tables with page locking
Berkeley_db
Alias for BDB
HEAP
No
Memory-based table; not persistent
ISAM
Obsolete format; replaced by MyISAM
InnoDB
Transaction-safe tables with row locking
MERGE
A collection of MyISAM tables merged as a single table
MyISAM
A newer , portable table type to replace ISAM