Subject | sizing cache |
---|---|
Author | Nick Upson |
Post date | 2013-05-14T09:00:22Z |
Hi,
I'm looking at increasing the cache size of my system to improve
performance but running into contradictory advice. (firebird 2.1.5 on
centos)
http://www.firebirdfaq.org/faq333/ says "... You should not set the cache
size to consume large part of your RAM...."
The new firebird book (p231) says " ...The first broad-brush optimization
you can try is to increase the default cache to a size that will occupy
approximately two-thirds of available free RAM. If there isn't enough RAM
installed, install more. ..."
This is a VM with 8GB RAM, 4vCPU, with maybe 10 connections, running
classic,
T
he book also (p231) says "use a monitoring tool to observe and record how
reads
and writes are satisfied from the cache" I've looked at several tools and
n
one seem to show this data, any suggestions what tool(s) to use here?
--
Nick Upson, Telensa Ltd
[Non-text portions of this message have been removed]
I'm looking at increasing the cache size of my system to improve
performance but running into contradictory advice. (firebird 2.1.5 on
centos)
http://www.firebirdfaq.org/faq333/ says "... You should not set the cache
size to consume large part of your RAM...."
The new firebird book (p231) says " ...The first broad-brush optimization
you can try is to increase the default cache to a size that will occupy
approximately two-thirds of available free RAM. If there isn't enough RAM
installed, install more. ..."
This is a VM with 8GB RAM, 4vCPU, with maybe 10 connections, running
classic,
T
he book also (p231) says "use a monitoring tool to observe and record how
reads
and writes are satisfied from the cache" I've looked at several tools and
n
one seem to show this data, any suggestions what tool(s) to use here?
--
Nick Upson, Telensa Ltd
[Non-text portions of this message have been removed]