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 |
Yes |
Alias for BDB |
HEAP |
No |
Memory-based table; not persistent |
ISAM |
No |
Obsolete format; replaced by MyISAM |
InnoDB |
Yes |
Transaction-safe tables with row locking |
MERGE |
No |
A collection of MyISAM tables merged as a single table |
MyISAM |
No |
A newer, portable table type to replace ISAM |