InnoDB v MyISAM
Terry Griffin edited this page Sep 21, 2015
·
5 revisions
- MYISAM supports Table-level Locking
- MyISAM designed more performing transactions quickly and less about row locking/commits/roll-backs/ or referential integrity.
- MyISAM does not support foreign keys hence we call MySQL with MYISAM a DBMS (minus the relational)
- MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI)
- MYISAM doesn't support transactions. You cannot commit and rollback with MYISAM. Once you issue a command it’s done.
- MYISAM supports fulltext search
- MyISAM performs better with selecting and less with updating and deleting.
- InnoDB supports Row-level Locking
- InnoDB designed for maximum performance when processing high volume of data
- InnoDB does support foreign keys and so MySQL with InnoDB is an RDBMS
- InnoDB stores its tables and indexes in a tablespace
- InnoDB supports transactions. You can commit and rollback.