Re: Stats ouput 9.3 vs 9.7
On 9/7/2011 11:13 AM, Baird, Josh wrote: Is there a way to revert back to the old stats format? Is there an easier way to reveal query stats via SNMP in 9.7? Any recommendations? I'm really looking to get QPS statistics. I can modify my parser script if necessary, but I thought I would check here first. Look at the statistics channel. Provides lot of information via XML. Some uses: http://www.zabbix.com/forum/showthread.php?t=11920 http://collectd.org/wiki/index.php/Plugin:BIND AlanC signature.asc Description: OpenPGP digital signature ___ Please visit https://lists.isc.org/mailman/listinfo/bind-users to unsubscribe from this list bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users
Re: Stats ouput 9.3 vs 9.7
At Wed, 7 Sep 2011 10:13:28 -0500, Baird, Josh jba...@follett.com wrote: Just upgraded some authoritative boxes to RHEL6, thus upgrading to BIND 9.7.3. On RHEL5 (BIND 9.3.x), I had scripts that parsed the output of the named.stats file, and piped them through net-snmpd so my NMS could monitor query statistics. On 9.3.x, the named.stats looked like: [...] Is there a way to revert back to the old stats format? Unfortunately not (at least not by tweaking named.conf or via build time options). It's a backward incompatible change (introduced in BIND 9.5, btw). --- JINMEI, Tatuya Internet Systems Consortium, Inc. ___ Please visit https://lists.isc.org/mailman/listinfo/bind-users to unsubscribe from this list bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users
RE: Stats ouput 9.3 vs 9.7
Thanks, Alan. So, I'm looking for the stats under the Server Statistics section if I want the same stats that 9.5 BIND produced, correct? Thanks, Josh -Original Message- From: bind-users-bounces+jbaird=follett@lists.isc.org [mailto:bind-users-bounces+jbaird=follett@lists.isc.org] On Behalf Of Alan Clegg Sent: Wednesday, September 07, 2011 1:16 PM To: bind-users@lists.isc.org Subject: Re: Stats ouput 9.3 vs 9.7 On 9/7/2011 11:13 AM, Baird, Josh wrote: Is there a way to revert back to the old stats format? Is there an easier way to reveal query stats via SNMP in 9.7? Any recommendations? I'm really looking to get QPS statistics. I can modify my parser script if necessary, but I thought I would check here first. Look at the statistics channel. Provides lot of information via XML. Some uses: http://www.zabbix.com/forum/showthread.php?t=11920 http://collectd.org/wiki/index.php/Plugin:BIND AlanC ___ Please visit https://lists.isc.org/mailman/listinfo/bind-users to unsubscribe from this list bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users
Re: stats brainteaser
On Fri, Jul 31, 2009 at 10:58 AM, Toddcanada...@gmail.com wrote: I've got a monitoring script in place that does an rndc stats and parses the output, then graphs it for me nicely. How is this being monitored? Are you sure its not an artifact of your monitoring software? I see this behaviour in mrtg/rrdtool when monitoring various dns stats. -- aRDy Music and Rick Dicaire present: http://www.ardynet.com http://www.ardynet.com:9000/ardymusic.ogg.m3u ___ bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users
Re: stats brainteaser
Todd wrote: Yesterday I needed to flush the cache on a number of my servers, and I saw a big spike in queries recorded by the server in the success category. The spike was about 40% more than the usual traffic. After a cache flush, the server has to re-fetch glue and nameserver records from the root up to the target names. This can cause a noticeable spike on a busy resolver. The statistics count these internal queries, too. So, my mental exercise is this ... does BIND not record a cache hit as a success? It does, AFAIK. If it was a success and not a cached negative response or other. Assuming my clients are doing say, 1000queries/second, and all 1000 are cache hits, do they show up as a success? They do, but so do successfully resolved cache misses. The number of cache hits is approximately (responses sent) - (queries caused recursion) Approximately, because the value includes answers from local authoritative zones, FORMERRs and other responses that did not come from the cache. Hauke. signature.asc Description: OpenPGP digital signature ___ bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users
RE: Stats
I know that people may laugh, but when I need to look at the stats, I pump the data into excel. A quick script turns that data into csv, pull into excel, highlght, graph, done! I've seen people using Cacti for graphing the numbers. RRD would work too, I believe. I expect you could feed the data in Concord (etc) if you wanted to be able to generate alerts. As for your error, it looks like that client is trying to update the zone with a record that already exists. Cheers, Todd. -Original Message- From: bind-users-boun...@lists.isc.org [mailto:bind-users-boun...@lists.isc.org] On Behalf Of John D. Vo Sent: Friday, March 27, 2009 9:25 AM To: bind-users@lists.isc.org Subject: Stats What do you guys use to turn this: --- Statistics Dump --- (1238151600) +++ Statistics Dump +++ (1238155200) success 3280261 referral 363 nxrrset 745513 nxdomain 392614 recursion 1173408 failure 1115632 --- Statistics Dump --- (1238155200) into something more meaningful? Also, what does this mean? I keep getting them in my logs: client 68.143.179.98#59977: updating zone 'gardencity.com/IN': update failed: 'RRset exists (value dependent)' prerequisite not satisfied (NXRRSET) TGIF! -- Best Regards, John D. Vo Eagle Teleconferencing Services, Inc. Network-System Administrator j...@eagle.net Office: (212) 200-2000 Ext. 105 Cell: (212) 200-3016 --- ___ bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users - This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users
Re: Stats
On Fri, 2009-03-27 at 09:25 -0400, John D. Vo wrote:
What do you guys use to turn this:
--- Statistics Dump --- (1238151600)
+++ Statistics Dump +++ (1238155200)
success 3280261
referral 363
nxrrset 745513
nxdomain 392614
recursion 1173408
failure 1115632
--- Statistics Dump --- (1238155200)
The following works (for me!) with either this (above) format
of dump or the richer format used in more recent BIND releases.
I'm not certain that the statistics selected for processing in
each case correspond exactly. I think they're pretty close.
#!/usr/bin/perl -w
use strict;
use Data::Dumper;
my $PROG = $0; $PROG =~ s|.*/||;
# Configuration
my $Config = {
statpath = '/var/named/run',
statfilename = 'named.stats',
probe = [ qw( /usr/local/sbin/rndc stats ) ],
};
my $State = {
skip = 0,
time = undef,
chain = [ { } ],
};
my $x;
# Result
my $MRTGdata = {
in = '-1',
out = '-1',
uptime = '0',
name = '0'
};
# Check that statpath directory exists
$x = $Config-{statpath};
-d $x or die(sprintf(%s: %s: %s\n, $PROG, $!, $x));
# Check that probe binary is a file and executable
$x = $Config-{probe}-[0];
(-f $x and -x $x) or die(sprintf(%s: %s: %s\n, $PROG, $!, $x));
# Save current size of file, if it exists
my $file = join('/', map { $Config-{$_} } (qw(statpath statfilename)));
$State-{skip} = (stat($file))[7] if ( -f $file );
# Save current time
$State-{'time'} = time();
# Issue probe
open(PROBE, '-|', @{$Config-{probe}})
or die $PROG: $!\n;
close PROBE;
# Collect data
open(FILE, '', $file)
or die(sprintf(%s: %s: %s\n, $PROG, $!, $file));
$State-{size} = (stat(FILE))[7];
seek(FILE,$State-{skip},0) if $State-{size} $State-{skip};
my @stats = FILE;
close FILE;
# Process stats
# warn join('', @stats);
for ( my ($i, $j, $phase, $stamp, $bucket) = (0, 0, 'IDLE');
$i scalar(@stats);
$i++ ) {
my $line = $stats[$i];
if ( $line =~ /^\++\s+Statistics Dump\s+\++\s+\((\d+)\)/ ) {
$stamp = $1;
if ($stamp = $State-{time}) {
$phase = $stamp;
$bucket = $State-{chain}-[++$j] = [ ];
$State-{chain}-[0]-{$phase} = $j;
push @$bucket, $i;
}
}
if ($phase eq 'IDLE') {
# warn $PROG: skipping: , $line;
next;
}
if ( $line =~ /^-+\s+Statistics Dump\s+-+\s+\((\d+)\)/ ) {
$stamp = $1;
if ($stamp eq $phase) {
push @$bucket, $i;
$State-{chain}-[0]-{last} = $State-{chain}-[0]-{$phase};
$phase = 'IDLE';
}
}
}
foreach my $chain ( $State-{chain} ) {
my $last = $chain-[0]-{last};
last unless defined $last;
my ($lo, $hi) = @{$chain-[$last]};
# warn sprintf(%s: scanning lines %d - %d\n, $PROG, $lo, $hi);
my $format = ( $stats[++$lo] =~ /^\+/ ) ? 'new' : 'old';
# warn $PROG: format: $format\n;
# Analyze new format
if ($format eq 'new') {
$MRTGdata-{in} = 0;
$MRTGdata-{out} = 0;
my $group = '';
foreach ( @stats[$lo .. $hi] ) {
$group = $1 if /^\++ (.*) \++/;
next unless $group eq 'Name Server Statistics';
$MRTGdata-{in} += $1 if /\s+(\d+) IPv4 requests received/;
$MRTGdata-{out} += $1 if /\s+(\d+) queries resulted in non
authoritative answer/;
}
}
# Analyze old format
elsif ($format eq 'old') {
$MRTGdata-{in} = 0;
$MRTGdata-{out} = 0;
foreach ( @stats[$lo .. $hi] ) {
$MRTGdata-{in} += $1 if /^success (\d+)/;
$MRTGdata-{in} += $1 if /^referral (\d+)/;
$MRTGdata-{in} += $1 if /^nxrrset (\d+)/;
$MRTGdata-{in} += $1 if /^nxdomain (\d+)/;
$MRTGdata-{in} += $1 if /^failure (\d+)/;
$MRTGdata-{out} += $1 if /^recursion (\d+)/;
}
}
}
# Present result as expected by MRTG
map {
printf %s\n, $MRTGdata-{$_}
} ( qw(in out uptime name) );
print \n;
___
bind-users mailing list
bind-users@lists.isc.org
https://lists.isc.org/mailman/listinfo/bind-users
Re: Stats
John D. Vo wrote: What do you guys use to turn this: --- Statistics Dump --- (1238151600) +++ Statistics Dump +++ (1238155200) success 3280261 referral 363 nxrrset 745513 nxdomain 392614 recursion 1173408 failure 1115632 --- Statistics Dump --- (1238155200) into something more meaningful? I appreciate all of the folks that have placed their recommendations into this thread, but I'd also like to point out that as-of BIND 9.5, we have a large number of new counters and statistics available. I think you might find the extended statistics quite a bit more useful. The following is a sample of the stats file from a lightly used 9.6.0-P1 recursive-only server: +++ Statistics Dump +++ (1238165353) ++ Incoming Requests ++ 1068222 QUERY ++ Incoming Queries ++ 393901 A 2053 NS 267592 CNAME 60 SOA 84166 PTR 84895 MX 234469 TXT 908 6 SRV 172 ANY ++ Outgoing Queries ++ [View: default] 270835 A 2157 NS 176485 CNAME 23 SOA 59429 PTR 84370 MX 142481 TXT 96621 3 SRV 27964 DS 2764 DNSKEY 18 ANY 26476 DLV [View: _bind] ++ Name Server Statistics ++ 1068222 IPv4 requests received 3 requests with EDNS(0) received 507 TCP requests received 13 recursive queries rejected 1065068 responses sent 14436 truncated responses sent 3 responses with EDNS(0) sent 533584 queries resulted in successful answer 1 queries resulted in authoritative answer 1054469 queries resulted in non authoritative answer 3 queries resulted in referral answer 204865 queries resulted in nxrrset 10585 queries resulted in SERVFAIL 316018 queries resulted in NXDOMAIN 559598 queries caused recursion 3154 duplicate queries received 13 other query failures ++ Zone Maintenance Statistics ++ ++ Resolver Statistics ++ [Common] [View: default] 819880 IPv4 queries sent 69746 IPv6 queries sent 786306 IPv4 responses received 68819 IPv6 responses received 193043 NXDOMAIN received 2813 SERVFAIL received 4011 FORMERR received 1996 other errors received 4356 EDNS(0) query failures 182 truncated responses received 4625 lame delegations received 73420 query retries 43837 IPv4 NS address fetches 46751 IPv6 NS address fetches 607 IPv4 NS address fetch failed 45039 IPv6 NS address fetch failed 580868 DNSSEC validation attempted 246943 DNSSEC validation succeeded 331719 DNSSEC NX validation succeeded 2206 DNSSEC validation failed [View: _bind] ++ Cache DB RRsets ++ [View: default] 35471 A 34966 NS 222 CNAME 1 SOA 7634 PTR 5636 MX 1632 TXT 419 9 DS 728 RRSIG 482 NSEC 45 DNSKEY 37 DLV 15 !A 1992 !CNAME 40 !MX 1400 !TXT 1114 ! 214 !DS 36 !DLV 1727 NXDOMAIN [View: _bind] ++ Per Zone Query Statistics ++ --- Statistics Dump --- (1238165353) signature.asc Description: OpenPGP digital signature ___ bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users
Re: Stats collection script for BIND 9.5 (and greater?)
At Tue, 16 Dec 2008 10:38:49 +0100, Alexander Gall g...@switch.ch wrote: Yes, if that assumption is correct, I don't see a big problem sticking to version 1.0 for the new format in 9.6.0 and 9.5.1. Still, if you do manage to get this particular change in (I guess it would be extremely localized and probably doesn't require any actual code change at all) that would be preferrable, IMHO. After an internal discussion, we've decided to bump the version number to 2.0. It's not included in 9.6.0rc2, but we don't plan to issue another RC for 9.6.0 just for this. The same change will appear in 9.5.1 (not included in 9.5.1rc2). Hopefully this won't happen a different type of compatibility issues. --- JINMEI, Tatuya Internet Systems Consortium, Inc. ___ bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users
