Thursday, March 18, 2010

Mysql Storage Engines

About Mysql storage engines :

ISAM

ISAM full form is Indexed Sequential Access Method, a method for indexing data for fast retrieval. ISAM was originally developed by IBM for mainframe computers.

Algorithm :



More about this ...


MyISAM :

MyISAM [full form] stands for Mysql Indexed sequential access method.

MySQL implements and extends ISAM as MyISAM.

-> MyISAM is a default storage engine for the MySQL relational database management system

-> MyISAM will not support transactions.

-> Additional inclusion from ISAM is referential integrity constraints, and higher concurrency.

More about MyISAM ...