[rrd-users] Re: remstats : dns-collector

[rrd]

Hi,

whith bind8 we have:
============
named.conf:
============
logging {
        channel stats_log {
                file "/logs/named/stats.log"
                versions 3
                size 200k;
                severity debug 99;
                print-category yes;
                print-severity yes;
                print-time yes;
        };
...
...
        category statistics { stats_log; };
...
...
}
options {
        statistics-interval 1; //this will dump stats each minute
...
...
};
=============
this generates every minute the following lines in stats.log
===
19-Jun-2003 14:49:22.223 statistics: info: USAGE 1056044984 1055413057
CPU=574.03u/239.77s CHILDCPU=0.03u/0.02s
19-Jun-2003 14:49:22.223 statistics: info: NSTATS 1056044984 1055413057
TYPE0=22 A=202200 NS=59 CNAME=75 SOA=380 PTR=287310 MX=28259 TXT=2596
AAAA=240315 LOC=9 SRV=684 A6=239116 ANY=1292
19-Jun-2003 14:49:22.223 statistics: info: XSTATS 1056044984 1055413057
RR=1546742 RNXD=801155 RFwdR=479434 RDupR=1294 RFail=24964 RFErr=69912
RErr=7232 RAXFR=0 RLame=28270 ROpts=0 SSysQ=454391 SAns=1290183 SFwdQ=771274
SDupQ=308751 SErr=0 RQ=1002317 RIQ=0 RFwdQ=771274 RDupQ=12843 RTCP=87
SFwdR=479434 SFail=311 SFErr=0 SNaAns=175832 SNXD=97575 RUQ=0 RURQ=3072
RUXFR=0 RUUpd=5262
===
NSTATS and XSTATS numbers are acumulative from startup.
so in config/rrds/namedstats2.rrd we have:
=======================
source log
step    300
times   day yesterday week 3month year
data    queries DERIVE:1200:0:60000 last \s+RQ=(\d+)\s+
data    aqueries DERIVE:1200:0:60000 last \s+A=(\d+)\s+
data    ptrqueries DERIVE:1200:0:60000 last \s+PTR=(\d+)\s+
data    mxqueries DERIVE:1200:0:60000 last \s+MX=(\d+)\s+
data    soaqueries DERIVE:1200:0:60000 last \s+SOA=(\d+)\s+
data    hinfoqueries DERIVE:1200:0:60000 last \s+HINFO=(\d+)\s+
data    locqueries DERIVE:1200:0:60000 last \s+LOC=(\d+)\s+
data    aaaaqueries DERIVE:1200:0:60000 last \s+AAAA=(\d+)\s+
data    zonexfers DERIVE:1200:0:10000 last \s+AXFR=(\d+)\s+
============

this is the data we need, you can get all if you want.
HTH

Nicolas Baumgarten

> -----Original Message-----
> From: Thomas Erskine [mailto:thomas.erskine at sympatico.ca]
> Sent: Thursday, June 19, 2003 11:09 AM
> To: Ed Schmollinger
> Cc: rrd_user_mail_list
> Subject: [rrd-users] Re: remstats : dns-collector
> 
> 
> At 09:52 2003-06-19, Ed Schmollinger wrote:
>  >On Thu, Jun 19, 2003 at 07:25:04AM -0400, Thomas Erskine wrote:
>  >> I'm sorry, but these rrds aren't likely to help people 
> who need it.  I'd
>  >> recommend djbdns instead, which does produce logs which can be
>  >> analyzed.  Unless newer versions of bind have some more 
> reasonable method
>  >> of getting stats out, I can't offer anything better in remstats.
>  >
>  >BIND9 writes to the statistics-file when you do 'rndc stats'.  You
> [snip]
> 
> Thanks for your kind offer of information.  I can (and will) 
> update the rrd 
> to use this, but can't test it any longer as I have no 
> installation to try 
> it on.  Does it maintain the counters between runs, or only 
> since startup?
> 
>  >The statistics-file in question is of the format
>  >+++ Statistics Dump +++ (1056027600)
>  >success 24373098
>  >referral 123288
>  >nxrrset 2534924
>  >nxdomain 1513560
>  >recursion 25508236
>  >failure 11206355
>  >--- Statistics Dump --- (1056027600)
>  >The numbers listed after success, referral, etc are all 
> counters, and
>  >the number in parenthesis on the "Statistics Dump" line is 
> the time at
>  >which the stat dump happened.
> 
>  >BIND8 writes statistics to the standard named log, assuming 
> that you've
>  >configured your logging options correctly.  Those are the XSTATS and
>  >NSTATS lines, read DNS and BIND by Albitz and Liu if you 
> feel a need to
>  >decode them.  (Your effort is probably better spent on updating to
>  >BIND9.)
> 
> Since people ought to be updating to bind9, and since I can't 
> test either 
> version, I'm disinclined to include bind8.
> 
>  >Both of those are fairly lightweight, and shouldn't cause 
> any noticable
>  >impact on your nameservers.
> 
> This is important info for me.
> 
> Thanks again for this usefull summary.
> 
>  >--
>  >Ed Schmollinger - schmolli at frozencrow.org
>  >
> 
> Thomas Erskine <thomas.erskine at sympatico.ca> +1.613.591.8490 
> 
> 
> --
> Unsubscribe 
mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi