Friday, April 1, 2011

Difference between myisam and innodb mysql engines

1) InnoDB storage engine of MySQL has support for transactions and automatic crash recovery while MyIsam don't.

2)Innodb has transaction support, commits and rollbacks, myisam don't.
3)MyIsam has full-text indexing, InnoDB doesn't.

4)InnoDB supports foreign key constraints.

No comments:

Post a Comment