Thursday, December 1, 2011

DIFFERENCE BETWEEN INNODB AND MyISAM


InnoDB is a high-reliability and high-performance storage engine for MySQL. Starting with MySQL 5.5, it is the default MySQL storage
engine. Key advantages of InnoDB include:
• Its design follows the ACID model, with transactions featuring commit, rollback, and crash-recovery capabilities to protect user
data.
• Row-level locking and Oracle-style consistent reads increase multi-user concurrency and performance.
• InnoDB tables arrange your data on disk to optimize common queries based on primary keys. Each InnoDB table has a primary
key index called the clustered index that organizes the data to minimize I/O for primary key lookups.
• To maintain data integrity, InnoDB also supports FOREIGN KEY referential-integrity constraints.
• You can freely mix InnoDB tables with tables from other MySQL storage engines, even within the same statement. For example,
you can use a join operation to combine data from InnoDB and MEMORY tables in a single query.


MyISAM: The MySQL storage engine that is used the most in Web, data warehousing, and other application environments. MyISAM
is supported in all MySQL configurations, and is the default storage engine prior to MySQL 5.5.5.


Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate
the file type. An .frm file stores the table format. The data file has an .MYD (MYData) extension. The index file has an .MYI
(MYIndex) extension.



No comments:

Post a Comment