MySQL Forums
Forum List  »  Performance

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
7803
January 26, 2009 06:22PM
Re: Which memory settings to change?
2736
January 28, 2009 12:39AM
2379
January 28, 2009 04:46PM
2200
January 29, 2009 01:24AM
2126
January 29, 2009 02:14PM
2172
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.