Subject RE: [ib-support] Server configuration
Author Gerhardus Geldenhuis
> >
> > My DB has a Pagesize of 4096 and my page buffer is 8192, then my
> > DB-Cache is 32 MB, right ? What does this mean exactly ? Does it mean,
> > that at the first connection to the DB 32 MB will be reserved in the RAM
> > or is the DB-Cache just a max Value ?
> >
> It is just a max value. It is complicated by the fact that even
> when allocated
> to ibserver, NT appears to keep a copy in virtual ram. Every page
> read from
> the databsae appears to lead to a page write to virtual memory.

> > Has someone experience with the SERVER_WORKING_SIZE_MIN and
> > SERVER_WORKING_SIZE_MAX parameters in the ibconfig ? I have set
> > SERVER_WORKING_SIZE_MIN to 128 MB and SERVER_WORKING_SIZE_MAX to 512 MB,
> > because I hoped, that IB will reserve 128 MB RAM at startup, but is
> > doesn't.
>
> Yeah, I have no idea why this stuff was ever documented. It has
> never seemed
> to work. Although it may have some relevance if you have a lot of
> memory and a
> lot of concurrent users. Each connection takes RAM over and above
> the Cache
> allocation.
>
This "memory problem" is it only relevant to Windows or to
other platforms as well. Does Linux have better handling of
the memory issue or is it primarily a architectural problem.

Groete
Gerhardus