|Subject||Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?|
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
- In the backup server
- Restore of the database using gbak.
- Check the return code of gbak and if it is different from zero there is a problem with the database.
And every week:
- Recalculate index statistics.
What do you think? These actions are enough? Would you change something?
thanks in advance for your kind help.
On Friday, May 4, 2018, 11:08:47 AM CDT, Javier Cintron fcintrono@... [firebird-support] <firstname.lastname@example.org> wrote:
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.