MySQL Pocket Reference: SQL Statements, Functions and Utilities and more (Pocket Reference (OReilly))

2017-07-07 02:10:07

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

Категории