Subject Re: [firebird-support] sizing cache
Author
You can use Sinatica monitor. It will show in a graphical way.
Em 14/05/2013 06:00, "Nick Upson" <nu@...> escreveu:

> **
>
>
> 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]
>
>
>


[Non-text portions of this message have been removed]