MySQL Forums
Forum List  »  Performance

Re: Which memory settings to change?
Posted by: BJ Quinn
Date: January 28, 2009 04:46PM

Thanks for the concise response, it's exactly what I was looking for!!

You're suggesting I give InnoDB maybe 70% of available RAM, and MyISAM 25%. Would I not be better off trying to see if it were possible to eliminate all my MyISAM tables in order to not have to allocate much to MyISAM, then maybe even more to InnoDB? Are the memory allocations hard caps or can they overlap a bit? (i.e. buffer_pool + key_buffer + OS RAM usage cannot be greater than 100% RAM)

I'm not looking for fine-tuning, just the major stuff. Is that pretty much all the settings I need to look at?


Options: ReplyQuote

Written By
January 26, 2009 06:22PM
January 28, 2009 12:39AM
Re: Which memory settings to change?
January 28, 2009 04:46PM
January 29, 2009 01:24AM
January 29, 2009 02:14PM
February 03, 2009 09:53AM

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.