MySQL Forums
Forum List  »  Newbie

Re: Which storage engine to choose?
Posted by: Ulf Wendel
Date: April 27, 2005 01:51PM

Arnold McIllroy wrote:
> I would like to know, which storage engine I
> should use in each case and why.

Q1: Do you need transactions (or foreign key constraints)?
Yes: InnoDB, BDB
No: all

Q2: Do you need persistent storage?
Yes: all, but MEMORY/HEAP
No: all

So, do you want to be on the safe side and use transactions? If you need transactions only to prevent trouble with concurrent accesses then, table locks and/or techniques like optimistic locking might be an alternative.

Note that you can mix different storage engines within one database. For example table A can be MyISAM and table B can be InnoDB.

Ulf

Options: ReplyQuote


Subject
Written By
Posted
Re: Which storage engine to choose?
April 27, 2005 01:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.