From owner-freebsd-isp@FreeBSD.ORG Fri Jun 11 17:19:52 2004 Return-Path: Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 269D716A4CE for ; Fri, 11 Jun 2004 17:19:52 +0000 (GMT) Received: from bes.amduat.net (bes.amduat.net [206.124.149.190]) by mx1.FreeBSD.org (Postfix) with ESMTP id BBEFA43D49 for ; Fri, 11 Jun 2004 17:19:51 +0000 (GMT) (envelope-from jbarrett@amduat.net) Received: from osiris.attachmate.com ([63.115.16.66]) (AUTH: LOGIN jbarrett, SSL: TLSv1/SSLv3,128bits,RC4-MD5) by bes.amduat.net with esmtp; Fri, 11 Jun 2004 10:19:45 -0700 From: "Jacob S. Barrett" To: freebsd-isp@freebsd.org Date: Fri, 11 Jun 2004 10:19:42 -0700 User-Agent: KMail/1.6.2 References: In-Reply-To: MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200406111019.42631.jbarrett@amduat.net> Subject: Re: Bandwidth Usage Billing X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Jun 2004 17:19:52 -0000 On Friday 11 June 2004 10:01 am, "Mitch (bitblock)" wrote: > I don't use cricket - we rolled our own, but the main advantage I have to > SQL storage, is that the numbers don't change - when 5 seconds become 20 > minute averages, your monthly numbers often change slightly, which gives > the "more alert" customers something to ask about ;-) Yeah, that is why we keep the 5 second data for 3 months. The default is something like 15 days, which obviously won't give you the most accurate accounting. We obviously keep a snap shot of each billing cycle, but we just let the data fade away over time. Until we start having customers come back and want a years worth of detailed reporting we probably won't keep the 5 second data longer than 3 months. For the picky customers we can easily increase it to a year. Besides, after a month the noticeable difference on the 5 second to 20 minute rounding is pretty small, less than a few megs, and since we are talking 10+Gs, no one really cares. :) -- Jacob S. Barrett jbarrett@amduat.net www.amduat.net "I don't suffer from insanity, I enjoy every minute of it."