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.
Asked
Active
Viewed 681 times
0
Community
- 1
- 1
gautamlakum
- 11,815
- 23
- 67
- 90
-
http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB – Mitch Wheat Mar 29 '11 at 06:25
-
http://en.wikipedia.org/wiki/InnoDB – Mitch Wheat Mar 29 '11 at 06:26
-
http://stackoverflow.com/questions/1970420/how-much-faster-is-myisam-compared-to-innodb – Mitch Wheat Mar 29 '11 at 06:27
-
http://stackoverflow.com/questions/4251179/mysql-innodb-vs-myisam – Mitch Wheat Mar 29 '11 at 06:28
-
a search of SO would pretty much answer your question.... – Mitch Wheat Mar 29 '11 at 06:29
-
check out innodb clustered indexes which most people overlook or fail to mention : http://stackoverflow.com/questions/4419499/mysql-nosql-help-me-to-choose-the-right-one-on-a/4421601#4421601 – Jon Black Mar 29 '11 at 08:02
1 Answers
0
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.
Adam Wagner
- 15,469
- 7
- 52
- 66