What is Differences between MyISAM and InnoDB Storage Engines in MySQL?
MyISAM: Default engine as of MySQL 3.23 with great performance.
InnoDB : Supports transactions, row-level locking, and foreign keys.
When you are using mysql there is myisam and innodb storage engine, most of the developer do not know the difference between this 2 engine. below is the explanation for both storage engine, once you read this you get idea about the storage engine difference.
1) InnoDB supports transaction and its also supports transactions, commits, rollbacks, foreign keys and row-level locking. this is one of the most important feature and because of that this storage engine give high performance then the MyISAM.
2) MYISAM does not support the foreign key constraint and transaction and because of that its give lower performance then InnoDB.
3) MYISAM is faster then the InnoDB because its not support transactions, foreign keys but in case of performing the count operation it takes more time then the InnoDB.
4) InnoDB storage engine occupy more memory space then MyISAM.
I hope now you are clear on the difference between Myisam and InnoDB storage engine.