What is difference between Innodb and MyISAM?

devquora

Posted On: Feb 22, 2018

Major differences between INNODB and MYISAM are

INNODB	MYISAM
InnoDB supports transactions	MYISAM does not support transactions
InnoDB ACID Compliant	Not ACID Compliant
InnoDB is default storage engine for MySQL 5.5 or above	MYISAM is default storage engine before MySQL version 5.5
Supports row-level locking	Supports table-level locking
Supports Foreign key constraints	Does not support Foreign key constraints/td>

Related Questions