What are the difference between and MyISAM and InnoDB?

These are most commonly used storage engine in MySQL are MyISAM and InnoDB.

Difference between MyISAM and InnoDB are given below:-

  • MyISAM does not support transactions, but InnoDB supports transactions.
  • MyISAM supports Table-level Locking, but InnoDB supports Row-level Locking.
  • MyISAM supports full-text search, but InnoDB does not.
  • MyISAM designed for the need of speed but InnoDB designed for maximum performance.
  • MyISAM does not support foreign keys, but InnoDB supports foreign keys.
  • We can use commit and rollback with InnoDB but not in MyISAM.
  • MyISAM does not support ACID (Atomicity, Consistency, Isolation, and Durability) but InnoDB supports the ACID property.
  • In InnoDB table, AUTO_INCREMENT field is a part of the index but not in MyISAM.
  • MyISAM stores its tables, data, and indexes in disk space using a separate table name.FRM, table name.MYD and table name.MYI but InnoDB stores its tables and indexes in a tablespace.

Suggest An Answer

No suggestions avaliable!

Latest post from Mysql Interview Questions

Ask Question