MySQL Table Types

Transaction Safe

Non Transaction Safe

Tables

Tables

INNODB

BDB

HEAP

ISAM

Merge

MyISAM

Default

Table

Dynamic

Stable

Compressed

Figure 5 3   MySQL table types

The following tables are the basic storage elements in MySQL:

InnoDB table

InnoDB is transaction safe storage engine with commit, rollback, and crash 

recovery capabilities. It provides locking on row level and also provides 

consistent non locking read in select statements for better concurrency and 

performance. 

InnoDB is a complete database service placed under MySQL. It has its own 

buffer pool for caching data and indexes in main memory. It supports multiple 

table spaces. It can be created using the statement:

mysql>create table itsoinnodb (i int ,f float ) type=innodb;

BDB table

Another type of transaction safe table in MySQL is BerkeleyDB (BDB). It 

supports page level locking, supports the commit and rollback features of the 

transaction, and is more stable while MySQL is in crash. It can be configured 

and created using the following commands:

100 

MySQL to DB2 UDB Conversion Guide