What is the difference between MyISAM and InnoDB?

There are lots of differences between both storage engines. Some are given below:-


  • MyISAM supports Table-level Locking, but InnoDB supports Row-level Locking
  • MyISAM designed for the need of speed but InnoDB designed for maximum performance when processing a high volume of data
  • MyISAM does not support foreign keys, but InnoDB support foreign keys
  • MyISAM supports full-text search, but InnoDB does not support this
  • MyISAM does not support the transaction, but InnoDB supports transaction
  • You cannot commit and rollback with MyISAM, but You can determine and rollback with InnoDB
  • MyISAM stores its data, tables, and indexes in disk space using separate three different files, but InnoDB stores its indexes and tables in a tablespace


This is a good question concerning PHP programming interview questions and answers for freshers.

Suggest An Answer

No suggestions avaliable!

Latest post from PHP interview questions

Ask Question