MySQL Forums
Forum List  »  Performance

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


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,

Options: ReplyQuote

Written By
InnoDB or MyISAM
February 22, 2011 05:57AM
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.