After reading Tapos Blog post about the differences between InnoDB and MyISAM database engines i found out that InnoDB does not only support row level locking but more then that, By doing a small fast research i came to those main differences:

  • The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction
  • InnoDB is for high volume, high performance
  • MYISAM does not support the foreign key constraint but InnoDB support it.
  • MYISAM is faster then the InnoDB but in case of perforing the count operation it takes more time then the InnoDB.
  • MYISAM occupies less memory sapce for tables rather than InnoDB tables.

Ultimately i think for a high level application InnoDB should be used. Otherwise MyISAM should do the job quite well.

If you would like to get a little more information about the performance of the two then there was a benchmark done here that shows some good results.