| Subject | Re: Firebird memory usage and/or configuration issue |
|---|---|
| Author | kettch_19 |
| Post date | 2009-07-22T14:06:59Z |
--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@...> wrote:
The settings that I am questioning are as follows:
DefaultDbCachePages = 16384
LockMemSize=16777216
LockSemCount=256
What would be reasonable values for these? It appears that since this is a Classic server that it is set to try and allocate all 16GB of memory right away which would obviously cause problems.
Thanks,
Ryan
>I sent a reply to this previously but it hasn't appeared in the list so I'll try again...
> Hi,
>
>
> What's the page cache/buffers of the database(check it by using GSTAT
> to retrieve the database headers)? It sounds like the page cache is
> set at a high value, but with Classic I would recommend that it would
> be set to 75 pages.
>
>
> --
> Best regards,
> Daniel Rail
> Senior Software Developer
> ACCRA Solutions Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>
The settings that I am questioning are as follows:
DefaultDbCachePages = 16384
LockMemSize=16777216
LockSemCount=256
What would be reasonable values for these? It appears that since this is a Classic server that it is set to try and allocate all 16GB of memory right away which would obviously cause problems.
Thanks,
Ryan