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.