Subject | Re: [firebird-support] Repeated database corruption |
---|---|
Author | Mark Rotteveel |
Post date | 2009-10-22T19:46:01Z |
If Page buffers is set to 0, the setting in firebird.conf is applied; so
if you change the setting in firebird.conf, everything will be OK.
Mark
Gustavo wrote:
Mark Rotteveel
if you change the setting in firebird.conf, everything will be OK.
Mark
Gustavo wrote:
> Thank you very much for your help.--
>
> I did gstat -h with one database and I got the following. I don?t find anything called "data page cache" but I guess perhaps what I have to check is "Page buffers", which is 0. Is it right what I am saying?
>
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 1720
> Page size 4096
> ODS version 11.1
> Oldest transaction 1710
> Oldest active 1711
> Oldest snapshot 1711
> Next transaction 1712
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 7
> Implementation ID 16
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Oct 21, 2009 22:39:25
> Attributes force write
>
> Variable header data:
> Sweep interval: 20000
> *END*
>
>
> ----- Original Message -----
> From: "Dimitry Sibiryakov" <sd@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Thursday, October 22, 2009 3:30 PM
> Subject: Re: [firebird-support] Repeated database corruption
>
>
>>> At server level, I found at firebird.conf, the configuration
>>> DefaultDbCachePages. There it says that for Super Server the default is 2048
>>> and for Client Server is 75. Is this configuration what I have to set
>>> between 256 and 1024?
>> Yes.
>>
>>> And where do I configure data page cache at database level?
>> 'gstat -h' will show you if you have it set for a particular
>> database. 'gfix -buffers' will allow you to change this setting, but I
>> would advice you not to do it.
>>
>> You can find description of both these utilities in Operations Guide
>> on documentation web page.
>>
>> SY, SD.
Mark Rotteveel