> 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?

FB TraceManager gives you the Cache Hit Ratio via monitoring tables and
via the Trace API.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.