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

Difference between MyISAM and InnoDB are given below:-
  • MyISAM does no longer support transactions, however InnoDB supports transactions.
  • MyISAM helps Table-level Locking, however InnoDB supports Row-level Locking.
  • MyISAM helps full-text search, however InnoDB does not.
  • MyISAM designed for the need for speed but InnoDB designed for most performance.
  • MyISAM does now not aid overseas keys, but InnoDB helps foreign keys.
  • We can use commit and rollback with InnoDB however not in MyISAM.
  • MyISAM does no longer assist ACID (Atomicity, Consistency, Isolation, and Durability) however InnoDB supports the ACID property.
  • In the InnoDB table, the AUTO_INCREMENT field is a section of the index but now not in MyISAM.
  • MyISAM stores its tables, data, and indexes in disk area the usage of a separate table name.FRM, desk name.MYD and table name.MYI however InnoDB stores its tables and indexes in a tablespace.
BY Best Interview Question ON 25 Nov 2020
Post Your Suggestion

Suggest An Answer

More Interview Questions from Database
SQL Interview Questions DBMS Interview Questions
Rdbms Interview Questions MongoDB Interview Questions
SQLite Interview Questions Oracle Interview Questions
MariaDB Interview Questions DB2 Interview Questions
SAP Hana Interview Questions Teradata Interview Questions