Subject Re: [firebird-support] sizing cache
Author Nick Upson
I looked at sinatica, I can only see a point where it says "cache" -
nothing about read & write figures and actual numbers would be more useful



On 14 May 2013 10:23, <fabianoaspro@...> wrote:

> 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]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>


--
Nick Upson, Telensa Ltd


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