Subject sizing cache
Author Nick Upson
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]