How Often Should you Archive Journal Files?
Go Up to Using Journal Archiving
Use the following statements and questions to help determine how often to archive journal files:
- How much data can you afford to lose if the IB server is destroyed?
- What is the journal rollover frequency? There is no reason to archive journal files more often that the journal rollover interval.
- Frequent journal rollover + frequent journal archiving means minimum data loss. However, too frequent journal rollover + too frequent journal archiving means poor performance. What is the best balance for your system?