Ads

Wednesday, 18 December 2013

What's the difference between MyISAM and InnoDB?

The difference between MySQL Table Type MyISAM and InnoDB are

MYISAM

MyISAM designed for need of speed
MYISAM supports Table-level Locking
MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI)
MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS
MYISAM supports fulltext search
You can use MyISAM, if the table is more static with lots of select and less update and delete.
MYISAM not supports transaction. You cannot commit and rollback with MYISAM. Once you issue a command it’s done.

INNODB

InnoDB designed for maximum performance when processing high volume of data
InnoDB supports Row-level Locking
InnoDB supports transaction. You can commit and rollback with InnoDB
InnoDB stores its tables and indexes in a tablespace
InnoDB support foreign keys hence we call MySQL with InnoDB is RDBMS

No comments:

Post a comment