May 6th, 2014 at 10:15 PM

Difference between InnoDB and MyIsam

First major difference is that InnoDB implements row level lock while Myisam can do only a table level lock.You will find the better crash recovery in InnoDB. However, it doesn't have full text search engine index, as does Myisam. InnoDB also inplement transctions, foreign keys and relationship constrain while Myisam does not.