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?
Thanks!
Subject
Views
Written By
Posted
8077
January 26, 2009 06:22PM
2833
January 28, 2009 12:39AM
Re: Which memory settings to change?
2459
January 28, 2009 04:46PM
2274
January 29, 2009 01:24AM
2189
January 29, 2009 02:14PM
2252
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.