So, these are the maintenance actions that I am going to perform every night(I
have a gap between 1am and 7 am):
- In the main server
- Backup using gbak.
- Restart o of the database to get rid of long transactions
- Sweep.
- In the backup server
- Restore of
What I mean is this: I want to know if a need to increment the page cache
buffer of Firebird.
And If was thinking of having some metric to measure it.
This metric would be very convinient If I need for example to justify buying
more memory for the server.
Thanks in advance.
04.05.2018 4:55, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote:
> what other regular maintenance actions does Firebird need in order to
> function properly?
It may be a good idea to recalculate index statistics from time to time.
--
WBR, SD.
Hello,
We recommend perform at least everyday sweep - with disconnect of long
running active writeable transactions before it.
Can you please clarify what do you mean by
> measuring the effectiveness of the page cache
?
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
On 04.05.2018