Automatic flushing of the jnl files

[Stuart Browne]

Bob,

Some date and record number details from one of my systems, with 'max-journal-size: 100m'.  Yes, I've changed the zone names.. ;)

NOTE: Add/Del numbers show total / non-dnssec-or-soa related update numbers.

'zone1' is a monitoring test zone that has sub-zone delegation changes a few times a minute:
	dnssec signed:	Yes, NSEC3 with Optout
	zone1 size:		127k
	one1.jnl size:	63M
	date now:		Wed Jan 21 22:12:15 UTC 2015
	oldest jnl soa:	Tue Jan 20 20:42:29 UTC 2015
	total records:	1,233
	no. SOA del's:	52,964
	no. del's:		236,556 / 79,716
	no. add's:		236,604 / 79,713

'zone2' is a public delegation zone that changes as customers demand:
	dnssec signed:	Yes, NSEC3 with Optout
	zone2 size:		176M
	zone2.jnl size:	100M
	date now:		Wed Jan 21 22:15:15 UTC 2015
	oldest jnl soa:	Fri Dec 19 17:22:20 UTC 2014
	total records:	5,917,482
	no. SOA del's:	138,752
	no. del's:		456,870 / 172,427
	no. add's:		478,940 / 194,541

'zone3' is a public authoritative zone that rarely changes:
	dnssec signed:	Yes, NSEC3 with Optout
	zone3 size:		1.6M
	zone3.jnl size:	69M
	date now:		Wed Jan 21 22:27:53 UTC 2015
	oldest jnl soa:	Mon Oct 27 21:19:38 UTC 2014 
	total records:	6,984
	no. SOA del's:	35,144
	no. del's:		175,832 / 0
	no. add's:		175,832 / 0

So the journal files can live for quite a while ;) 

Stuart

> -----Original Message-----
> From: bind-users-bounces at lists.isc.org [mailto:bind-users-
> bounces at lists.isc.org] On Behalf Of Tony Finch
> Sent: Thursday, 22 January 2015 6:34 AM
> To: Bob Harold
> Cc: bind-users at lists.isc.org
> Subject: Re: Automatic flushing of the jnl files
> 
> Yes, an IXFR is a series of deletes and adds, which both quote whole
> records. If you re-sign a zone the IXFR can be nearly twice what an AXFR
> would be! But in fact the factor of two in my patch comes from the journal
> compaction logic, which halves the size of the journal. So my patch allows
> the journal to oscillate between the size of the zone and twice that.
> Smaller journals may mean you have to AXFR when IXFR would be better.
> 
> If you use serial-update-method unixtime or date-based serial numbers then
> you might be able to get the information you want from the journal.
> 
> Tony.
> --
> f.anthony.n.finch  <dot at dotat.at>  http://dotat.at
> 
> > On 21 Jan 2015, at 18:37, Bob Harold <rharolde at umich.edu> wrote:
> >
> > I like that solution.
> >
> > I assume that "twice the zone file size" is because half of the entries
> are deletes?  Do deletes get sent in IXFR?  Or is it that typically half
> of the journal entries are SOA records?
> >
> > I just took a peek at my journal files and I see one that is 100 times
> the zone file size.  I wish the entries had dates, even if just as a
> comment - it would be a good log of changes, and I would be able to see
> how far back in history the journal went.
> >
> _______________________________________________
> Please visit https://lists.isc.org/mailman/listinfo/bind-users to
> unsubscribe from this list
> 
> bind-users mailing list
> bind-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/bind-users