Re: Which memory settings to change?
Posted by:
Rick James
Date: January 28, 2009 12:39AM
InnoDB -- yes make its buffer_pool ~70% of available RAM -- say 6GB on an 8GB machine. It holds both the data and index blocks.
MyISAM -- yes key_buffer is the main tunable -- make it perhaps 25% of available ram. It holds indexes only; Unix takes care of data blocks. Do not go over 4GB, even with a 64-bit build.
Query Cache -- Multiple cores tend to stumble over each other; better to turn OFF the QC unless you have a good use for it. If it is DEMAND or ON, still 100MB is a huge amount for it.
Intensive queries? Often they (and/or their indexes) can be tuned to run faster.
max_connections of 100 is plenty for most people. 1000 is possible on an 8GB machine, but they will be stumbling over each other.
Subject
Views
Written By
Posted
8120
January 26, 2009 06:22PM
Re: Which memory settings to change?
2847
January 28, 2009 12:39AM
2476
January 28, 2009 04:46PM
2292
January 29, 2009 01:24AM
2208
January 29, 2009 02:14PM
2270
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.