File

Description

columns_priv.MYD

columns_priv.MYI

Permission for individual columns within a table

columns_priv.frm

host.MYD

host.MYI

General permission by host

host.frm

tables.MYD

tables.MYI

Permission for individual tables within a database

tables.frm

user.MYD

user.MYI

General Permission by user

user.frm

MySQL table types

MySQL supports two different types of table:

Not transaction safe tables which are:

  ISAM

  MyISAM

  HEAP

  MERGE

Transaction safe tables which are:

  InnoDB

  BDB

Database systems that support simultaneous users must ensure that changes to 

the database cannot corrupt the database or leave it in an inconsistent state. 

Most RDBMS can bundle multiple updates (adds, changes, or deletes) together 

into transactions; see Example 1 1. Transactions have four important features 

usually referred to as the ACID properties: 

Atomic:

Transactions either completely succeed or completely fail. If the system 

crashes before the transaction completes the database's state does not 

change. 

34 

MySQL to DB2 UDB Conversion Guide