mysql innodb vs MyISAM [duplicate]

This question alr开发者_开发问答eady has answers here: Closed 11 years ago.

Possible Duplicate:

MyISAM versus InnoDB

Hi there,

In MySQL, which storage engine is faster? InnoDB or MyISAM? Can any one list their +/- here? not detailed list but in short.

Thanks.

---

I'm not sure you can get a definitive answer. I think MyISAM is faster for many simple queries, however, it only has table-level locks. InnoDB, on the other-hand uses row-locking, which could mean things are faster when you are running multiple large queries concurrently.