MySQL Forums
Forum List  »  Performance

Re: InnoDB vs. MyISAM: RAM Needed?
Posted by: James Day
Date: February 03, 2005 08:40PM

Having InnoDB present will use perhaps 10MB more RAM. Beyond that it's really a question of the size of your index entries and how much RAM you need to allocate to the caches. The index entries in InnoDB won't be compressed, unlike those in MyISAM, so they may take more RAM if they are text with long common prefixes, say. Because MyISAM and InnoDB don't share the same buffer pool it can take some trial and error to find the best mixture.

It's simpler to manage the cache if it's all InnoDB or all MyISAM. You might experiment with all InnoDB to see whether allocating all of the available cache RAM to InnoDB provides sufficient beneit to offset any penalty you might have in some queries from MyISAM. Testing is the way to go to find out what works best.

Options: ReplyQuote


Subject
Views
Written By
Posted
3773
February 03, 2005 10:22AM
Re: InnoDB vs. MyISAM: RAM Needed?
2859
February 03, 2005 08:40PM
2542
February 04, 2005 11:53AM
1918
February 08, 2005 01:56PM


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.