Subject | Re: AW: AW: [firebird-support] How to test for forced writes? |
---|---|
Author | Norman Dunbar |
Post date | 2011-01-26T16:59:10Z |
Hi Steffen,
The forced writes are on by default on Linux, Windows NT, XP, 2000,
2003, Vista and I presume 7 as well. (According to the above page!)
However, your 2.0.4 version will not show this in the attributes, until
you explicitly set the sync mode using gfix.
I would advise you to run a "gfix -write sync <database name>" manually
after creating the database9s) if you absolutely must know that forced
writes are on. That way, a run of "gstat -h <database name>" will report
that forced writes are on.
Other than that, I'm not sure how else you could find out - unless you
upgrade to 2.5 of course, where gstat will show that forced writes are
on immediately after creation.
HTH
Cheers,
Norman.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
> However I am on 2.0.4 (and currently bound to that) and I need to decidehttp://www.firebirdsql.org/manual/gfix-sync.html
> from linux on command line, whether forced writes is on.
> Can you give me any hint?
The forced writes are on by default on Linux, Windows NT, XP, 2000,
2003, Vista and I presume 7 as well. (According to the above page!)
However, your 2.0.4 version will not show this in the attributes, until
you explicitly set the sync mode using gfix.
I would advise you to run a "gfix -write sync <database name>" manually
after creating the database9s) if you absolutely must know that forced
writes are on. That way, a run of "gstat -h <database name>" will report
that forced writes are on.
Other than that, I'm not sure how else you could find out - unless you
upgrade to 2.5 of course, where gstat will show that forced writes are
on immediately after creation.
HTH
Cheers,
Norman.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767