MySQL Forums
Forum List  »  MyISAM

Significance of Primary Keys
Posted by: Ira Holtzer
Date: September 24, 2010 07:04AM


Our developers created a history solution to record activity for our site based on MyISAM. If it matters, there are many inserts and very few selects/updates being done on this DB.

The developers did not specify in any of the tables a primary key.

What would MyISAM do in this scenario?
Will it choose some PK for itself? If yes, how do I know which PK it chose?
How can this affect performance? What do I need to consider?
I saw a lot of material on how InnoDB stores the data, and a lot of comparisons saying that MyISAM is different in that respect, but couldn't find any good explanation as to how and what the implications are.

Ultimately my question is, whether I should request adding primary keys, and if yes, should I use surrogate or natural ones?


Options: ReplyQuote

Written By
Significance of Primary Keys
September 24, 2010 07:04AM
September 25, 2010 12:06PM

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.