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
Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2
Besides, backing up my databases and measuring the effectiveness of the page
cache, what other regular maintenance actions does Firebird need in order to
function properly?
thanks in advance