MySQL Forums
Forum List  »  Performance

InnoDB or MyISAM
Posted by: Jim Buckley-Barrett
Date: February 22, 2011 05:57AM

Hi,

I have a database that is 4GB in size, one table in particular is 3GB, all the others make up the other 1GB. That 3GB table has an engine type of MyISAM, I do mostly INSERT and SELECT. There isn't any UPDATE.

My question - is the MyISAM best for this table or should I change it to another engine storage type like InnoDB?

Thanking you in advance,
Jim

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB or MyISAM
1401
February 22, 2011 05:57AM
598
February 23, 2011 08:45AM


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.