Possible Duplicate:
Should I always prefer MySQL InnoDB over MyISAM?
I just wanna know in what situation we will use MyISAM? in what situation we will use INnoDB?
Asked
Active
Viewed 714 times
0
Community
- 1
- 1
user1026927
- 11
- 1
-
http://stackoverflow.com/questions/1970160/should-i-always-prefer-mysql-innodb-over-myisam – makes Nov 03 '11 at 03:44
2 Answers
1
http://www.kavoir.com/2009/09/mysql-engines-innodb-vs-myisam-a-comparison-of-pros-and-cons.html
http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB
There are many differences, data integrity, locks, transactions to name a few, for good design u may wanna go through these links once. Pros and Cons are mentioned in detail in a simplistic manner
Zohaib
- 7,026
- 3
- 26
- 35
-
1+1 Good links, but you could place the main pros / cons within your answer. – Tadeck Nov 03 '11 at 03:46
-
0
A very basic run-down of my decision-making is: "table-lock = MyISAM, row-lock = InnoDB".
Of course there's more to it than that, but that's all that really matters for me.
Niet the Dark Absol
- 320,036
- 81
- 464
- 592