What is the difference between MyISAM and InnoDB?

1.	What is the difference between MyISAM and InnoDB?
Answer» There are lots of differences between 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 supports 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 Note This is a good question concerning PHP interview questions for experienced.

Answer»

There are lots of differences between 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 supports 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

Note This is a good question concerning PHP interview questions for experienced.

Discussion