Subject | Re: [firebird-support] How to list current DB settings |
---|---|
Author | K. Kumakura |
Post date | 2006-11-27T09:55:50Z |
Hi Kimura,
Thank you for your suggestion.
set stat;
commit;
yields the following:
Current memory = 563928
Delta memory = -4812
Max memory = 612496
Elapsed time= 0.06 sec
Buffers = 2048
Reads = 0
Writes 2
Fetches = 2
'Buffers =' seems to show cache buffer size.
What about 'write(sync or async)' and other settings
that we can set with gfix?
BTW, 'gstat -head' lists some but not all of settings
that we can set with gfix.
Thanks,
K,Kumakura
Thank you for your suggestion.
set stat;
commit;
yields the following:
Current memory = 563928
Delta memory = -4812
Max memory = 612496
Elapsed time= 0.06 sec
Buffers = 2048
Reads = 0
Writes 2
Fetches = 2
'Buffers =' seems to show cache buffer size.
What about 'write(sync or async)' and other settings
that we can set with gfix?
BTW, 'gstat -head' lists some but not all of settings
that we can set with gfix.
Thanks,
K,Kumakura