<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
<br>Thank you for your reply!<br>For some reason I was thinking of the xff the other way around. I'm using your ideas, and it looks promising.<br>Regards Henrik<br><hr id="stopSpelling">From: s.shipway@auckland.ac.nz<br>To: henrikhegardt@hotmail.com; rrd-users@lists.oetiker.ch<br>Subject: RE: [rrd-users] Questions about effective database parameters<br>Date: Wed, 15 Dec 2010 01:27:16 +0000<br><br>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
<style>
.ExternalClass .ecxhmmessage p
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
</style><style>
.ExternalClass P
{margin-bottom:0;}
</style>
<div style="direction: ltr; font-family: Tahoma; color: rgb(0, 0, 0); font-size: 13px;">
<div style="">RRA:AVERAGE:0.5:30:720 <br>
RRA:AVERAGE:0.5:60:720 <br>
<br>
You need to set the XFF (the fraction of the data which must be known for an RRA to store a value) to be much lower; in fact, you might even want to make it as near to zero as you can, maybe 1/(#dp)<br>
<br>
So, for the above, use:<br>
<br>
RRA:AVERAGE:0.03:30:720 <br>
RRA:AVERAGE:0.01:60:720 <br>
<br>
and even make it smaller for other RRAs.<br>
<br>
This is a rather clever way to get around the whole data normalisation thing; by making the step size 1s you avoid normalisation, but use a tiny XFF to make sure your 1-min RRA still stores the data as posted (and averages if you get multiple samples).<br>
<br>
Steve<br>
</div>
<div><br>
<div style="font-family: Tahoma; font-size: 13px;">
<div style="font-family: Tahoma; font-size: 13px;"><strong>Steve Shipway</strong></div>
<div style="font-family: Tahoma; font-size: 13px;">University of Auckland ITS</div>
<div style="font-family: Tahoma; font-size: 13px;"><em>UNIX Systems Design Lead</em></div>
<div style="font-family: Tahoma; font-size: 13px;"><a href="mailto:s.shipway@auckland.ac.nz">s.shipway@auckland.ac.nz</a></div>
<div style="font-family: Tahoma; font-size: 13px;">Ph: +64 9 373 7599 ext 86487</div>
<div style="font-family: Tahoma; font-size: 13px;"><em></em> </div>
</div>
</div>
<div style="font-family: Times New Roman; color: rgb(0, 0, 0); font-size: 16px;">
<hr>
<div style="direction: ltr;" id="ecxdivRpF285712"><font color="#000000" face="Tahoma" size="2"><b>From:</b> rrd-users-bounces+s.shipway=auckland.ac.nz@lists.oetiker.ch [rrd-users-bounces+s.shipway=auckland.ac.nz@lists.oetiker.ch] on behalf of Henrik Hegardt [henrikhegardt@hotmail.com]<br>
<b>Sent:</b> Tuesday, 14 December 2010 10:59 p.m.<br>
<b>To:</b> rrd-users@lists.oetiker.ch<br>
<b>Subject:</b> [rrd-users] Questions about effective database parameters<br>
</font><br>
</div>
<div></div>
<div>Hello.<br>
I'm writing a program to monitor a server's activities. Its about response times for services on the server. There are quite many services and most of the written data are unknowns. The response times is quite crucial and would want to have as high resolution
as possible even though there are unknowns. If there's a response time I write it to the DB with 1 second interval though since there are several other services per rrd a update operation could look like 'update database.rrd 1292313983:U:U:U:U:U:U:U:0.012:U:U:U:U:U:U'.
I would like to store it for atleast 6 months and thus view it over that time. I'm not interested of if there was no value, but the value itself.<br>
I can't tell if there will be a lot of updates during a time interval or none at all which should result in some of the entries won't even get a 'U' value (most probably).<br>
I have worked with following<br>
rrdtool create -s 1 \<br>
DS:ds1:GAUGE:2:0:3600 \<br>
...<br>
RRA:AVERAGE:0.5:30:720 <br>
RRA:AVERAGE:0.5:60:720 <br>
RRA:AVERAGE:0.5:420:720<br>
RRA:AVERAGE:0.5:1800:720 <br>
RRA:MAX:0.5:30:720 <br>
RRA:MAX:0.5:60:720 <br>
RRA:MAX:0.5:420:720 <br>
RRA:MAX:0.5:1800:720<br>
<br>
This didn't work, since I believe there a lot more 'U' values than 0.5 and the resolution isn't good enough and really doesn't make sense according to what I'm trying to sample.<br>
RRA:AVERAGE:0.5:1:86400 worked but then having a rra over 6 months (6*30*86400) will result in a big db and slow rendering of images. Any ideas?<br>
<br>
Forgive my English.<br>
<br>
<br>
</div>
</div>
</div> </body>
</html>