What is difference between Innodb and MyISAM?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

Major differences between INNODB and MYISAM are

INNODBMYISAM
InnoDB supports transactionsMYISAM does not support transactions
InnoDB ACID CompliantNot ACID Compliant
InnoDB is default storage engine for MySQL 5.5 or aboveMYISAM is default storage engine before MySQL version 5.5
Supports row-level lockingSupports table-level locking
Supports Foreign key constraintsDoes not support Foreign key constraints/td>

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mysql Interview Questions

    What is MySql ?

    MySql is a multi-threading, multi-user open source SQL database management system . It is typically used for web applica..

    Mysql Interview Questions

    In which language MYSQL it is written ?

    MySql is written in C and C++ programming and SQL parser written in yacc...