[rrd-users] Re: Graph with two colors
Two possibilities: 1. Feed your rrds with two different sources, one with the part of the value up to 50, the other one with the part higher than 50. Then graph first source as AREA green and STACK second source red. 2. CDEF two values, Value1: If load 50 then Value1=50, Value2=load-50. Then graph Value1 as AREA green and STACK Value2 red. HTH, Stephan Wengrzik, Andreas wrote: Hi List! I have a Graph which is drawn by one value (cpuload) I draw an hrule greater than 50 I select the values greater than 50 and draw them red, now i want to draw only the part of the value red which is above the hrule ?! Is this possible? Here´s my actually definition: DEF:as400cpu=$f:as400cpu:AVERAGE CDEF:cpu1=as400cpu,50,GT,UNKN,as400cpu,IF CDEF:cpu2=as400cpu,50,LE,UNKN,as400cpu,IF AREA:cpu1#82BB6C:\Prozessorauslastung OK\ AREA:cpu2#E24545:\Prozessorauslastung Kritisch\ HRULE:50#D0D000:\Warning level\ HRULE:100#E0:\Kritisches Level\ LINE1:cpu1#00 LINE1:cpu2#00 GPRINT:as400cpu:MAX:\Maximale Auslastung\\: %.4lg Prozent\ GPRINT:as400cpu:MIN:\Minimale Auslastung\\: %.4lg Prozent\ GPRINT:as400cpu:AVERAGE:\Durchschnittliche Auslastung\\: %.4lg Prozent\ -- Stephan Harren Head of Engineering AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: IP Traffic Calculation
Sure you can, you just have to know how much traffic is sent to an IP at specific intervals. Then you can add the values for example with the PREV-function. The point here is, that rrdtool is not thought to be a traffic analyser, it is just a tool to store, calculate and graph values that are known. Cheers, Stephan Zeeshan Ahmed wrote: Hai, Is there any way we can calculate the total IP traffic usage on an IP address using RRD-Tool. Like If I can get the total bits or bytes sent and received on a specific IP. Regards, Zeeshan Ahmed IP CMTS Specialist WorldCALL Multimedia Pvt Ltd 16-S Gulberg II Lahore, Pakistan Off: 92(042) 5877051-55 Cell: (92) 03009414363 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Stephan Harren Head of Engineering AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Excluding UNKN or NAN from CDEF
Hi Eric, I think, it might be good for you to read the tutorials and manuals about rrdtool. But anyways, what do you want to achieve? Showing everything allright when there are NaN's? It is not very nice to say: Okay, if I don't know what happened, probably everything was allright.. But ok, there is one line that defines Cleaned: CDEF:Cleaned=Response,UN,0.0,Response,IF This line sets all NaN to 0.0, insert whatever you want instead of the 0.0. Cheers, Stephan Eric Brander wrote: It works very well, except that since this is a new setup, the historical graphs have little data and the SLA line takes the NANs as failures. Again, I've taken this from someone else's example and I must admit that I really don't understand exactly what those statements mean. My question to you: Is there a way I can build the SLA line without it incorporating NANs or Unknowns in to its equation? -- Stephan Harren Head of Engineering AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] [Fwd: Re: Re: Excluding UNKN or NAN from CDEF]
Good suggestion but its result is not quite what I was looking for. This makes all unknowns = 0.0 (or in my case I tried 1.0 - which made the graphs look far more successful than they should be) Again, the only acceptable result would be to eliminate unknowns entirely. Unknowns ARE ignored when calculating, so try not to use the use 0 instead of NaN-Statements: DEF:Response=\mrtg\log\WebCheck\TEST.rrd:ds0:AVERAGE CDEF:ResponseSum=PREV,UN,0,PREV,IF,Response,+ CDEF:One=Response,-1,GT CDEF:OneSum=PREV,UN,0,PREV,IF,One,+ CDEF:Uptime=ResponseSum,OneSum,/ CDEF:UptDisp=Uptime,100,* CDEF:AboveSLA=Uptime,0.9,GE,Uptime,UNKN,IF AREA:Response#3399ff:Response from Webserver HRULE:0.9#00:SLA 90 %\n LINE3:Uptime#FF:UpTime below SLA LINE3:AboveSLA#00FF00:Uptime Above SLA\n GPRINT:UptDisp:MAX:Uptime Max %.2lf %% GPRINT:UptDisp:MIN:Min %.2lf %% GPRINT:UptDisp:AVERAGE:Mean %.2lf %% GPRINT:UptDisp:LAST:Last %.2lf %%\n COMMENT:Last Update: 09/27/2004 7:36:45 AM\r But I guess, this will probably also have some disadvantages, because calculating with NaNs can lead to strange effects. Giv it a try, but I'd also prefer to use the cleaned version. Stephan -- Stephan Harren Head of Engineering AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Excluding UNKN or NAN from CDEF
Hi Alex, yes you're right, but in this case, 1,0,0,unknown will result in 33% as the calculation is made like: count all values -1 add all values divide counted/added CDEF:ResponseSum=PREV,UN,0,PREV,IF,Cleaned,+ CDEF:One=Cleaned,-1,GT CDEF:OneSum=PREV,UN,0,PREV,IF,One,+ CDEF:Uptime=ResponseSum,OneSum,/ which means, when counting, nans are ignored, when adding nans are ignored so you'll find 1/3. But I hope that this is exactly what Eric wants to achieve. Cheers, Stephan AFAIK unknowns are ignored when averaging. In other words: 1,1,1,unknown,1 will result in 100%, 1,0,0,unknown will result in 25% Easy to check, when you run a script on a database with known content. Just build a test-rrd, put some data in it and create some graphs. HTH Alex -- Stephan Harren Head of Engineering AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: rrd-tool frontend
Real men don't click ;-)) No, sorry, I don't know of any, but to really understand what's going on, it might be very important to you to dig into the command line. Cheers, Stephan Ernest Byaruhanga wrote: hello rrdusers, i am looking for a frontend to rrd-tool that will help me quickly build graphs without going into text editors. (well, some people prefer the easy way when its available) :) i have looked at Cacti and netmrg. is there any other recommended one (before i delve into these two?) -- Stephan Harren Head of Engineering AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: how to get a step of 60
Hi, take a look some lines upward. This 900 seems to me, that it is your consolidated graph. You generate 1 data point out of 15, so 15x60=900 which seems right to me. Cheers, Stephan M. Possamai wrote: At 10:30 19-8-2004, M. Possamai wrote: 1092901500: NaN NaN 1092902400: NaN NaN 1092903300: NaN NaN 1092904200: NaN NaN To me this looks like a step of 100.. I don't want 100, I want 60.. Correction, that's not even a step of 100... I only looked at the last 3 digits... (D0H!) it's a step of 900. Yet, it's still not a step of 60... Grtz M. Possamai (still waking up.. need more coffee apparently) -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: how to get a step of 60
Yep, I thought he did a rrdtool export, but that's what he probably should do to see that rrdtool is doing right and to understand a little more about rrdtool and what it does. Cheers, Stephan No, the step is not wrong. You are asking for a certain amount of data and RRDtool is answering to the best of its abilities. There is only two hours worth of data in the 60-second RRA so if you are asking for more than two hours, RRDtool has no other choice than to select another RRA. In general: RRDtool is NOT doing anything wrong. You are, because you did not read or understand the documentation. And yes, this is true for many new users that come bashing this list with remarks like rrdtool is wrong, the step is wrong, rrdtool is misleading. Alex -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: newbie question (creating an rrd that is updated occasionally)...
And actually, that's the solution. rrdtool create foo.rrd -b -100days -s # of secs in 30 days DS:...etc.. RRA:LAST:...etc.. Now you should pick the last timestamp from your rrd that exists, doing so by rrdtool dump foo.rrd. Then you update your rrd with exactly this timestamp, after about another thirty days with the next timestamp=timestamp+ # of secs in 30 days by doing rrdtool update bla bla timestamp:value. It doesn't matter if you do that after maybe 31 or 32 days, but be sure to provide the right timestamp. The secret is that it's always a rate, so take care of heartbeat and step. A good idea for your example is to take a step of 30 days and a heartbeat of 60 days. If you then provide the values with the exact timestamps you'll have that value valid for exactly thirty days. HTH, Stephan Eric Ho wrote: actually, that's the dilemma. let's say that I created the rrd w/: rrdtool create foo.rrd -b -100days -s X DS:...etc.. RRA:LAST:...etc.. where X = # of secs in 30 days. Now, if I update it w/ timestamp, T, where T may not lie at the beginning of the month, I get strange results when I fetch foo.rrd. -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: One area printed over another
I'd propose to stack the values onto each other. Sometimes a good idea is also to display a percentage, so you'll always end up with 100 (if you stacked both values). Not really necessary because if you don't, you'll end up with the max amount of free space on your disk, just a question of taste. SO, my solution would be to STACK both values with different coulours. HTH, Stephan Benni Graf wrote: Hi! Right now I'm learning how to produce some nice graphs with rrdtool and it's pretty amazing, but a problem came up: I want to print two Areas in one Graph: One with used Disk Space and another one with free Disk Space. Currently I've got more used than free Disk Space, so everything is fine, because i've written the AREA-command for the used Disk Space before the AREA-command for the free Disk Space. But if there is more free Disk Space than used, the Area of the free Disk Space is printed over the Area of the used Disk Space, so i cannot see the used Space-Area. Surely this is not a big Problem in this example (who needs to see free and used Disk Space at once? ;-) ), but i think in other cases it could be a problem... So can you help me? BTW: You can see the Graphs and the Source-Code here: http://benni.homelinux.net/rrd/graph/index.php Nice Greetings, Benni Graf. -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: reasonable maximums
It's 100*1000*1000 (because 1 Megabyte means 1024*1024, but 1 Megabit means 1000*1000, the theoretical maximum on a FastEthernet is 100.000.000). But if you store the data in bytes and multiply it by 8 when graphing, your maximum should be 12.500.000 (because the maximum is still 100.000.000, divided by 8 will be bytes). HTH, Stephan Dan Mahoney, System Admin wrote: Hi, I was unsure of how my graphs would be built initially, as I'm monitoring ipfw rules with a theoretical limit of 100 megs (although in theory the loopback can go faster, we'll assume it won't). It probably doesn't matter, but my counters return bytes, but the standard seems to be bits, so I'm multiplying the data * 8. With this in mind, what should I set my maximum as? Is it as simple as 100 * 1024 * 1024 (104857600) or am I missing something that'll bite me in the behind later? Thanks, and happy new year. -Dan Mahoney -- You're a daddy. I'm a mommy. She's our baby. Deal with it. -Cali, 11/7/02, about 1:35 AM Dan Mahoney Techie, Sysadmin, WebGeek Gushi on efnet/undernet IRC ICQ: 13735144 AIM: LarpGM Site: http://www.gushi.org --- -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: problems with timestamps
Hi, start doesn't refer to end but to the actual timestamp! HTH, Stephan nono wrote: Hi, i'm trying to graph with this command : /usr/bin/rrdtool graph out.png \ --imgformat=PNG \ --start=-3600 \ --end=1072685876 \ and the resulting error is : ERROR: start (1072775356) should be less than end (1072685876) How rrdtool calculates that 1072685876 - 3600 = 1072775356 ??? -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Remove Data Source
Spencer Anderson wrote: Hi, I'd like to remove a data source and all associated data from an RRD. I know I can use the rrdtool dump command to export the database into an XML file and edit the XML file, but I can't remove everything associated with the data source I want to remove fast enough so that I can get the XML updated and restored before my next data update. Is there a faster (more reliable then my highlighting and deleting) way to do this? Sorry, I don't know any other way than to write a nice script (maybe perl will be the right way) that will do for you. This will be more than fast enough and will also be reliable if you take care when developing ... HTH, Stephan -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Remove Data Source
Arnold Nipper wrote: Indeed, this would be a special case of merging two RRD files ... Stefan, you already wrote this tool (there was enough time the last days) ;-)) Otherwise I will have to do it on my own :-( but s/perl/gawk+sh/ Hello Arnold, just as I told you, I won't do that for you until I get an order for doing that. Next point is, didn't you mention that you're able to do that in 30mins? And last point, this is a list for technical questions and discussions, so please keep that comments off list. If you're keen on discussing such stuff, mail to my private address. Best regards, Stephan -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: help with error please
Try the following: - Make sure that your output file (GIF/PNG) is formatted like this: c:\\inetpub\\graphs\\output.gif - Make sure that your RRD definitions are like this: c\\:\\inetpub\\wwwroot\\mrtg\\rrdtool\\drmateo_e4.rrd:ds0:AVERAGE If this doesn't work (I use this in my perl scripts), try single backslashes. Best regards, Stephan Van den Bossche Eric wrote: Hi all, can someone try to find the error here (i'm not that experienced with RRD) C:\Inetpub\wwwrootrrdtool.exe graph c:\inetpub\wwwroot\sher-member-01_mem_fault s_Daily.png -s -2000m -e now -a PNG -w 800 -h 300 --alt-y-grid --lazy -c MGRID#e e -c GRID#00 DEF:in=c:\mrtg_workdir\sher-member-01\sher-member-01_mem_fa ults.rrd:ds0:AVERAGE DEF:out=c:\mrtg_workdir\sher-member-01\sher-member-01_mem_f aults.rrd:ds1:AVERAGE CDEF:pin=in,100,/,100,*,1,/ CDEF:pout=out,1000 000,/,100,*,1,/ DEF:min=c:\mrtg_workdir\sher-member-01\sher-member-01_mem_faults .rrd:ds0:MAX DEF:mout=c:\mrtg_workdir\sher-member-01\sher-member-01_mem_faults.r rd:ds1:MAX AREA:in#005499:Maximal Incoming Traffic\l LINE1:out#e52325:Maximal Outgoing Traffic\l GPRINT:min:MAX:Max In\: %8.3lf %s GPRINT:pin:MAX:(%3.0lf %%) GPRINT:mout:MAX:Max Out\: %8.3lf %s GPRINT:pout:MAX:(%3.0lf%%)\l GPRINT :in:AVERAGE:Avg In\: %8.3lf %s GPRINT:pin:AVERAGE:(%3.0lf%%) GPRINT:out:AVER AGE:Avg Out\: %8.3lf %s GPRINT:pout:AVERAGE:(%3.0lf%%)\l GPRINT:in:LAST:Cur In\: %8.3lf %s GPRINT:pin:LAST:(%3.0lf%%) GPRINT:out:LAST:Cur Out\: %8.3lf %s GPRINT:pout:LAST:(%3.0lf%%)\l ERROR: can't parse DEF 'in=c:\mrtg_workdir\sher-member-01\sher-member-01_mem_fau lts.rrd:ds0:AVERAGE' -2 Greetings Eric -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: tool for merging rrd files
That's easily done by hand, rrdtool export both into xml, merge them and kick what you don't need, rrdtool restore. Could write something, but that needs an order, because it needs some hours of work. Best regards, Stephan Arnold Nipper wrote: I've moved a lot of ports from one switch to another and now want to merge both rrd files, the new ones and the old ones. I've browsed the archive and googled around but couldn't find a descend tool. What I'm looking for is a script what when given rrd file rrd1, rrd file rrd2 and timestamp t produces a new rrd file rrd3 with samples up to t from rrd1 and samples beginning at t from rrd2. Anyone did see such a tool? Regards, Arnold -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Stephan Harren Leiter Technik AboveNet Deutschland GmbH - Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: nan after about 6 hours of data collection
Try this:
rrdtool create icmp.rrd \
-s 60 --start 1071682900 \
DS:one:GAUGE:120:0:U \
DS:two:GAUGE:120:0:U \
DS:three:GAUGE:120:0:U \
DS:four:GAUGE:120:0:U \
RRA:AVERAGE:0.5:1:720 \
RRA:AVERAGE:0.5:5:720 \
RRA:AVERAGE:0.5:30:336 \
RRA:AVERAGE:0.5:120:360 \
RRA:AVERAGE:0.5:1440:365 \
maybe it's a problem with your heartbeat/step combination.
perl e 'print scalar localtime(1071682900).\n;'
solves your second issues.
Best regards,
Stephan
[EMAIL PROTECTED] wrote:
Hello all,
I am pretty new to RRD, started playing with in 2 days ago. I created an rrd,
which will be updated per minute, and I populated it with data continuously
every 30 minutes using rrdtool update. But data after about 6 hours are all
nan. here are my exact configs
rrdtool create icmp.rrd \
-s 60 --start 1071682900 \
DS:one:GAUGE:60:0:U \
DS:two:GAUGE:60:0:U \
DS:three:GAUGE:60:0:U \
DS:four:GAUGE:60:0:U \
RRA:AVERAGE:0.5:1:720 \
RRA:AVERAGE:0.5:5:720 \
RRA:AVERAGE:0.5:30:336 \
RRA:AVERAGE:0.5:120:360 \
RRA:AVERAGE:0.5:1440:365 \
I am not fully sure of the RRA sections are correct, my intentions are to
create a graph of 5 min average for 24 hours, 30 min average for a week, 2
hours average for a month and day average for a year.
I have collected data from 1071682903 till 1071734374 and stored in a
directory in files in format
1071682903 264 43 3748 73113
which is inserted into rrd using an awk script
$ cat backup/* | awk -f icmp.awk | bash
[EMAIL PROTECTED]:~/rrd$ cat icmp.awk
BEGIN{ print #!/bin/sh}
{ printf rrdtool update icmp.rrd %d:%d:%d:%d:%d\n, $1,$2,$3,$4,$5}
actual output to bash is like
#!/bin/sh
rrdtool update icmp.rrd 1071682903:264:43:3748:73113
rrdtool update icmp.rrd 1071682963:201:33:3748:69307
rrdtool update icmp.rrd 1071683024:216:42:983:71250
rrdtool update icmp.rrd 1071683084:193:36:2782:65270
rrdtool update icmp.rrd 1071683144:206:46:3948:71803
and so on...
This gets updated to rrd with out any problems
[EMAIL PROTECTED]:~/rrd$ cat backup/* | awk -f icmp.awk | bash
[EMAIL PROTECTED]:~/rrd$
now when I plot the graph, data is available only till about 8:00, on further
investigation using rrdfetch
one two three four
1071734040: 2.597500e+02 5.83e+01 2.245110e+04 1.474257e+05
1071734100: 3.252500e+02 8.135000e+01 2.192325e+04 1.4996735000e+05
1071734160: 4.49e+02 1.27e+02 2.223400e+04 1.461190e+05
1071734220: 2.54e+02 6.40e+01 1.964800e+04 1.495270e+05
1071734280: 2.960333e+02 7.396667e+01 2.031100e+04 1.486872e+05
1071734340: 3.072333e+02 7.40e+01 2.185790e+04 1.4831656667e+05
1071734400: nan nan nan nan
1071734460: nan nan nan nan
1071734520: nan nan nan nan
1071734580: nan nan nan nan
1071734640: nan nan nan nan
1071734700: nan nan nan nan
and it is nan for remaining data. Any idea how this happened? I am totally
clue less, gone through all the manuals and tutorials but no clue about this!
also is their any tool to convert from and to seconds and other date formats?
ie the datetime of say 1071734400?
Thanks for your time,
raj
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
--
Stephan Harren
Leiter Technik
AboveNet Deutschland GmbH
-
Phone +49 69 90554 153
Fax +49 69 90554 111
Cell +49 173 7011126
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Can you add more DS Data Sources to an already existing rrd database?
Am Donnerstag, 4. Dezember 2003 15:46 schrieb Good, Steve: I am just starting to use RRD, and getting away from MRTG. The documentation for the RDD is good. I was able to quickly use the tool. Lets say I am setting up an RRD for the temperature of 8 routers. I know I can use the resize to grow or shrink the size, and I can use tune to change some of the values. What I am trying to find, is if I add more routers to my environment and wish to also record their temperature, is there a way to add additional DS entries to the rrd? The only thing I could think of was to create the rrd, with some dummy names, and rename them later when I add more routers. Thanks, Steve Never found an option like that. What you can always do, is to export your data into xml, generate a new rrd with more datasources and then restore the xml-data (quite unhandy). HTH, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: create new rra (monthly 5 minutes average)
see below: Am Dienstag, 2. Dezember 2003 16:28 schrieb Andras Horvai: Hi, I would like to create a new rra as I wrote in the e-mail subject, monthly 5 minutes average. But I miss something. When I create the graph it exactly represents the same graph what the monthly 2 hours average. What can be wrong? this is the source of the graph: rrdtool graph - \ --imgformat=PNG \ --start=-2678400 \ --title=stat \ --rigid \ --base=1000 \ --height=120 \ --width=500 \ --alt-autoscale-max \ --lower-limit=0 \ --vertical-label=bits per second \ DEF:a=/cacti/traffic_198.rrd:traffic:AVERAGE \ DEF:b=/cacti/traffic_199.rrd:traffic:AVERAGE \ CDEF:cdefa=a,8,* \ CDEF:cdefh=b,8,* \ AREA:cdefa#00CF00:Inbound \ GPRINT:cdefa:LAST: Current\:%8.2lf %s \ GPRINT:cdefa:AVERAGE:Average\:%8.2lf %s \ GPRINT:cdefa:MAX:Maximum\:%8.2lf %s\n \ COMMENT:\n \ HRULE:0#FF:95th Percentile \ COMMENT:(0 kbit in)\n \ LINE1:cdefh#002A97:Outbound \ GPRINT:cdefh:LAST:Current\:%8.2lf %s \ GPRINT:cdefh:AVERAGE:Average\:%8.2lf %s \ GPRINT:cdefh:MAX:Maximum\:%8.2lf %s\n \ COMMENT:\n \ HRULE:0#00:95th Percentile \ COMMENT:(0 kbit out) rrdtool create \ /cacti/traffic_199.rrd \ --step 300 \ DS:traffic:COUNTER:600:0:1 \ Your maximum is probably wrong, you'll have to divide it by 8 if you don't want to allow peaks that are 800 MBit/s. RRA:AVERAGE:0.5:1:600 \ RRA:AVERAGE:0.5:6:700 \ RRA:AVERAGE:0.5:1:17280 \ RRA:AVERAGE:0.5:24:775 \ RRA:AVERAGE:0.5:288:797 \ Why do you keep two times 0.5:1 ? I don't think that this will work. Kick the lines RRA:AVERAGE:0.5:1:600 so that it will look like: RRA:AVERAGE:0.5:1:17280 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:79 RRA:MAX:0.5:1:17280 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797 Do that for both datasources! HTH, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: lost data on graph
OK, now I think I know your problem. You were using the AVERAGE-consolidation when creating. So far so good. But when you use thousands of values and only use 400 pixels of width, all the values are consolidated to some (by averaging because it's an AVERAGE) and from this the MAX is CDEFed, so you're going to lose your peaks. You cannot force rrdtool to use step=1, just because it wouldn't fit into the graph. As I saw, you changed behaviour in the scripts that you sent to me. There you use the MAX consolidation so you won't lose peaks. Is that understandable? If not, please get back to me. HTH, Stephan After creating a graph with: +++ rrdtool graph graph_name \ DEF:forms_processtime=forms_processtime.rrd:forms_processtime:AVERAGE LINE1:forms_processtime#FF \ GPRINT:forms_processtime:MAX:%lf \ -s $start_time_in_sec_6am -e $cur_time_in_sec \ --no-minor -a PNG -w 400 -h 300 \ -t *Forms Run Time Performance Data for $cur_server +++ I saw the MAX value display is 0.096. I know that I have other values that are higher than 0.096, ie 0.226, 0.119, etc..., which I confirm with the fetch function: +++ rrdtool fetch forms_processtime.rrd AVERAGE -r 1 -s 1068922800 -e 1069392186 | grep -v nan | grep -F e-01 1068955200: 2.263133e-01 1068963000: 1.190800e-01 1068991200: 1.344733e-01 1069020300: 1.173800e-01 1069033200: 1.216867e-01 1069058100: 1.109200e-01 1069071600: 1.412133e-01 1069107300: 2.002800e-01 1069111800: 2.464533e-01 1069331100: 1.173600e-01 1069348200: 1.474933e-01 +++ So, why is the graph not showing 0.236 and 0.119? -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Problems with graphic of week and year
Read the tutorial / manual to rrdtool graph on www.rrdtool.org! You just store 288 5-minute-values which is exactly one day, so how should rrdtool graph data which it doesn't know? RRA:LAST:0.5:1:288 HTH, Stephan Viaris schrieb: Hi ALL. I need to graph the real amount, not average, of in and outgoing mail that I am monitoring with RRDTOOL. I have tree different graphs: a daily, week and annual. My problem is that it gives you the daily data but it does not hold the historical data. For example: if today is Tuesday, I can read and display the information from today but neither from Monday nor Sunday. -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: lost data on graph
Am Montag, 17. November 2003 14:51 schrieb Li, Charles: These values are inside my begin and end time for the graph. Please send your files and exact statements to me (don't post files to the list) and I'll take a look at it. Best regards, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: suppress return value
How about adding '/dev/null' at the end of the rrdtool statement, that's just shell as usual? HTH, Stephan Am Freitag, 14. November 2003 20:34 schrieb Raj Subramaniyan: Can I by any chance suppress the return value (gif size) returned by 'rrdtool graph'? I am calling rrdtool graph inside a script using system command. I do not want it to spit out anything to stdout. Assigning the command to a variable does not seem to help my case as I cannot do that in my script. -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: lost data on graph
After creating a graph with: +++ rrdtool graph graph_name \ DEF:forms_processtime=forms_processtime.rrd:forms_processtime:AVERAGE LINE1:forms_processtime#FF \ GPRINT:forms_processtime:MAX:%lf \ -s $start_time_in_sec_6am -e $cur_time_in_sec \ --no-minor -a PNG -w 400 -h 300 \ -t *Forms Run Time Performance Data for $cur_server +++ I saw the MAX value display is 0.096. I know that I have other values that are higher than 0.096, ie 0.226, 0.119, etc..., which I confirm with the fetch function: +++ rrdtool fetch forms_processtime.rrd AVERAGE -r 1 -s 1068922800 -e 1069392186 | grep -v nan | grep -F e-01 1068955200: 2.263133e-01 1068963000: 1.190800e-01 1068991200: 1.344733e-01 1069020300: 1.173800e-01 1069033200: 1.216867e-01 1069058100: 1.109200e-01 1069071600: 1.412133e-01 1069107300: 2.002800e-01 1069111800: 2.464533e-01 1069331100: 1.173600e-01 1069348200: 1.474933e-01 +++ So, why is the graph not showing 0.236 and 0.119? Maybe your timeframe for the graph doesn't include these values? Best regards, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: DS merge.
Am Mittwoch, 12. November 2003 11:59 schrieb Carles Xavier Munyoz Baldó: Hi, I have a RRD database file in which I store 3 data source values. I would like to merge the values of the 3 data sources. With the graph I have no problem because I use AREA to plot the 3 data sources with the same colour, this way I get a one colour graph with the 3 data sources merged. The problem is in the legend, how may I print the merged result values for the 3 data sources in the LAST, CURRENT, and MAX legend values ? If you want to add your DSes, solution would be: CDEF:sum=ds1,ds2,+,ds3,+ (Maybe you should do: CDEF:sum=ds1,UN,0,ds1,IF,ds2,UN,0,ds2,IF+,ds3,UN,0,ds3,IF,+ to avoid unknown values) Then graph sum and GPRINT sum with LAST, MAX. If you want to put it all into one graph so that the highest will win, CDEF will be: CDEF:merge=ds1,ds2,GT,ds1,ds2,IF CDEF:result=merge,ds3,GT,merge,ds3,IF example: rrdtool graph --start 1068612000 test.png DEF:ds1=merge.rrd:ds1:AVERAGE DEF:ds2=merge.rrd:ds2:AVERAGE DEF:ds3=merge.rrd:ds3:AVERAGE CDEF:merge=ds1,UN,0,ds1,IF,ds2,UN,0,ds2,IF,GT,ds1,UN,0,ds1,IF,ds2,UN,0,ds2,IF,IF CDEF:result=merge,ds3,UN,0,ds3,IF,GT,merge,ds3,UN,0,ds3,IF,IF PRINT:result:LAST:LAST\: %02.0lf PRINT:result:MAX:MAX\: %02.0lf PRINT:result:MIN:MIN\: %02.0lf Then GPRINT result with LAST,MAX. HTH, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Calculating a sum of averages?
This works great, except when all files for a user gets deleted from a partition - then the daily cron job doesn't update the RRD file for that partition with any data - and so a NaN gets generated. That is okey for the BWSUM value, but I'd still like the GWSUM value to be computed correctly (ie be equal to AWSUM). I tried fixing the problem by modifying the CDEF to be: CDEF:partX=kpartX,UN,0,kpartX,IF,1024,\* But that causes GWSUM to be be equal to the old GWSUM value divided by two... Should work, please post all your statements exactly (incl. create ...) Best regards, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Timestamp MAX/MIN value
Looks nice,
but if you want to graph and GPRINT on the command line, that wouldn't work.
Yes, I know, in a script I can do the timestamp find-out before graphing
and then graph the variable, but I find it quite unflexible.
Best regards,
Stephan
Am Donnerstag, 6. November 2003 17:48 schrieb Serge Maandag:
I think not.
I like to do it in bash, b.t.w., looks just as good as my average perl
code:
rrdtool dump database.rrd | grep 'row' | sed 's/^[ ]*//;s/[
]*$//' | cut -d -f9,6 | awk '{print $2,$1}' | sort -g | tail -1 | cut
-d -f2
Serge.
--
Stephan Harren
Manager Site Operations
AboveNet Deutschland GmbH
---
Phone +49 69 90554 153
Fax +49 69 90554 111
Cell +49 173 7011126
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: AW: Re: AW: GRAPH Problem
GPRINT:innentemp:MAX:Maximale Innentemperatur %.0lf \n GPRINT:innentemp:MIN:Minimale Innentemperatur %.0lf \n Das \n am Ende sollte zumindest für einen Zeilenumbruch sorgen, in der letzten Mail hatte ich, glaube ich, die vergessen. Wenn das noch nicht reicht, kannst Du einen COMMENT:\n zwischen die einzelnen GPRINTs schieben, dann hast Du eine Leerzeile. Gruss, Stephan Am Dienstag, 4. November 2003 19:09 schrieben Sie: WUNDERBAR . Danke Nur wie bekomme ich die Daten jetzt noch Untereinander sieht ein wenig Verschroben aus *ggg* -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: confused
When I do: rrdtool update epic229_forms_processtime.rrd 1067969500:0.5 rrdtool update epic229_forms_processtime.rrd 1067969501:0.5 rrdtool update epic229_forms_processtime.rrd 1067969502:0.5 rrdtool update epic229_forms_processtime.rrd 1067969503:0.5 and do: rrdtool fetch epic229_forms_processtime.rrd AVERAGE -s 1067969500 -e 1067969503 -r 1 I get: 1067969500: 5.00e-01 1067969501: 5.00e-01 1067969502: 5.00e-01 1067969503: 5.00e-01 But when I go: rrdtool fetch epic229_forms_processtime.rrd AVERAGE -s 1067969506 -e 1067969503 -r 1 rrdtool fetch epic229_forms_processtime.rrd AVERAGE -s 1067969508 -e 1067969503 -r 1 I get: 1067969506: 5.00e-01 1067969507: nan 1067969508: nan 1067969509: nan 1067969510: nan I wonder why you get any data when you configure an end that lies before start!?! Also as far as I can see, you just put in values for 1067969500-1067969503 so what do you want? Best regards, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: confused
Am Mittwoch, 5. November 2003 15:09 schrieb Li, Charles: Sorry. My mistake. I mean to say that I issue updates to time 1067969506 and 1067969508(instead of fetch). So, when I do the fetch, the value for 1067969508 came up as nan, even though I put in data. Please explain what I did wrong. Thanks Charles Cannot see, what you did wrong, maybe try again and post exactly the steps you made. Best regards, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Timestamp MAX/MIN value
Hi All, is there an easier way to find out the timestamps of MAX-/MIN-values without using bash or something than the one I found (see below)? /usr/local/rrdtool-1.0.45/bin/rrdtool graph -a PNG test.png DEF:innentemp=test.rrd:innentemp:AVERAGE CDEF:maxvalue=innentemp,UN,0,innentemp,IF,PREV,UN,0,PREV,IF,MAX CDEF:maxtime=innentemp,UN,0,innentemp,IF,PREV\(maxvalue\),GE,TIME,PREV,IF CDEF:minvalue=innentemp,UN,INF,innentemp,IF,PREV,UN,INF,PREV,IF,MIN CDEF:mintime=innentemp,UN,INF,innentemp,IF,PREV\(minvalue\),LE,TIME,PREV,IF AREA:innentemp#FF: 6 STD Verlauf PRINT:innentemp:MAX:Maximum Temperature %.0lf PRINT:innentemp:MIN:Minimum Temperature %.0lf PRINT:maxtime:LAST:maxtime %.0lf PRINT:mintime:LAST:mintime %.0lf Best regards, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: GRAPH Problem
Ich Paste mal meine Befehlszeile hier rein, vielleicht kann mir da jemand ergänzend helfen, Ich bin was Englisch anbelangt ein Ziemlicher DAU und Glücklich das rrdtools überhaupt bei mit läuft nach viel Frikelei /usr/local/rrdtool-1.0.45/bin/rrdtool graph /var/www/web1/html/wetter/stdinnen.png -s -6h -v Grad Celsius DEF:innentemp=/usr/local/rrdtool-1.0.45/bin/messpc.rrd:innentemp:AVERAGE AREA:innentemp#FF: 6 STD Verlauf Innentemperatur GPRINT:innentemp:MAX:Maximale Innentemperatur %.0lf\n GPRINT:innentemp:MIN:Minimale Innentemperatur %.0lf\n Wenn Du die rrd-Befehle innerhalb von scripts verwenden willst, musst Du das eine oder andere escapen (backslashen). Die 0 in .0lf deutet übrigens auf 0 Kommastellen hin. HTH und Gruss, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: AW: GRAPH Problem
Wenn ich es richtig Verstanden habe muß die Zeile jetzt so aussehen? /usr/local/rrdtool-1.0.45/bin/rrdtool graph /var/www/web1/html/wetter/stdinnen.png -s -6h -v Grad Celsius DEF:innentemp=/usr/local/rrdtool-1.0.45/bin/messpc.rrd:innentemp:AVERAGE AREA:innentemp#FF: 6 STD Verlauf Innentemperatur:GPRINT:innentemp:MAX:Maximale Innentemperatur %.0lf\n:GPRINT:innentemp:MIN:Minimale Innentemperatur %.0lf\n Nö, falsch verstanden ;-)) /usr/local/rrdtool-1.0.45/bin/rrdtool graph /var/www/web1/html/wetter/stdinnen.png -s -6h -v Grad Celsius DEF:innentemp=/usr/local/rrdtool-1.0.45/bin/messpc.rrd:innentemp:AVERAGE AREA:innentemp#FF: 6 STD Verlauf Innentemperatur GPRINT:innentemp:MAX:Maximale Innentemperatur %.0lf\n GPRINT:innentemp:MIN:Minimale Innentemperatur %.0lf\n Ich hoffe, jetzt stimmt es, habe es nicht ausprobiert und gerade keine Zeit. Wenn es immer noch nicht funzt, bitte Bescheid geben. Gruss, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Wrong values from rrd fetch
How about using PREV? You can CDEF:oldvalue=actualvalue, oldtime=TIME. Then you can use CDEF:roc=actualvalue,PREV(oldvalue),-,TIME,PREV(oldtime),-,/ Best regards and HTH, Stephan assumption: ROC = (y1 - y0) / (x1 - x0) my rrd is a gauge of disk space used in bytes. i assume all I need is to keep the first byte value (y0) and first timestamp (x0), then cdef it like this: CDEF:roc=y1,y0,-,TIME,x0-,/ but howto save first values (time = x0, bytes = y0)? this doesnt work: CDEF:y0=y0,UN,used,y0,IF CDEF:x0=x0,UN,TIME,x0,IF Howto save first values? any other suggestions for ROC calculation? -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: rate of change
How about using PREV? You can CDEF:oldvalue=actualvalue, oldtime=TIME. Then you can use CDEF:roc=actualvalue,PREV(oldvalue),-,TIME,PREV(oldtime),-,/ Best regards and HTH, Stephan assumption: ROC = (y1 - y0) / (x1 - x0) my rrd is a gauge of disk space used in bytes. i assume all I need is to keep the first byte value (y0) and first timestamp (x0), then cdef it like this: CDEF:roc=y1,y0,-,TIME,x0-,/ but howto save first values (time = x0, bytes = y0)? this doesnt work: CDEF:y0=y0,UN,used,y0,IF CDEF:x0=x0,UN,TIME,x0,IF Howto save first values? any other suggestions for ROC calculation? -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Wrong values from rrd fetch
920804400: nan 920804460: 1.20e+01 920804520: 1.396667e+01 920804580: 1.216667e+00 920804640: 7.88e+00 920804700: 7.016667e+00 920804760: 6.016667e+00 920804820: 2.07e+00 920804880: 2.17e+01 920804940: 2.298333e+01 920805000: 2.398333e+01 920805060: nan I think that this is the same problem like David Knecht had but I don`t know how to correct it , to get 24 instead 23,98333.. Normalize the timestamp: timestamp_to_use=int(timestamp_now/60)*60 or timestamp_to_use=sprintf(%.0f,(timestamp_now/60))*60 Best regards and HTH, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: rrds::graph error
5.6.1-34.99.6 and with RRDTool-0.17. Here is the code segment that I am Tried your options with rrdtool-1.0.39 and it worked without any problems. Maybe you should update because in older versions these options might not be included. HTH, Stephan -- Stephan Harren Manager Site Operations AboveNet Deutschland GmbH --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Timestamp for MAX value...
The easiest way I know is to write a perl script with rrdtool fetch for the timeframe and search for the highest one. Best regards, Stephan Am Mittwoch, 24. September 2003 23:50 schrieb James Mancini: Does anyone know if there is an easy way to get RRD to return the timestamp at which a MAX value occurred? Thanks in advance... -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: problem
I created an RRA rrdtool create test.rrd -s 5 \ DS:getal:GAUGE:60:U:U \ RRA:LAST:0.5:1:50 \ RRA:LAST:0.5:2:20 Did you insert this values with or without timestamp? The point is, that your rrd accepts one value every 5 seconds, and one value gets unknown, if you don't insert something for 60 seconds. As you see, the first value you inserted was 979 (just once). So every five seconds, it's 979 because there is no new value but the old one is valid, (because it has been inserted during the last 60 seconds). As you see, taking care of step and heartbeat is very important. 607.8 comes from 4 times 515 plus 979 divided by 5, which means the last input that has been made was 979, but through the next 4 datapoints there was just 1 input made, which now becomes valid for calculation since then. Again the problem is the step/heartbeat ratio is the problem. Example: 10 - 979 15 - No Input 20 - No Input 25 - No Input 30 - 515 leads to 10 - 979 15 - 979 20 - 979 25 - 979 because at 25, 20, 15 there was no input, but there is a known and still valid datapoint. 30 - 6.087 Internally (not in the table, above of it, if you use rrdtool fetch) there is the last input at 10 still saved. Now there is a new input at 30. As they are both valid (because of heartbeat 60),there is a rate calculated which leads to this confusing result. And so on ... If you insert one value every five seconds with the exact timestamp, this won't happen, but if I was you, I would work on the step/heartbeat ratio. You can find a lot about this on the rrdtool homepage. Hope this helps and did not lead to any further confusion. And by the way, I hope that I'm right ;-)) (Tobi, correct me if I'm wrong) Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Operational status of interface
Am Dienstag, 2. September 2003 13:15 schrieb Dayo Adeyeye: Hello, How can the operational stsus of the interfaces of the routers im monitoring be included in my rrd graphs ? get the status via snmp and feed a separate datasource with it. Then graph this datasource for example with a negative value for up and down. HTH, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Can't Parse DEF error on NT
Try backslashing the : after C -- C\:, just a guess, never tried Best regards, Stephan Am Dienstag, 12. August 2003 18:53 schrieb Alvaro Cornejo: I've installed it and runs with no problem when the .rrd file is on the same directory as the rrdtool.exe. When the .rrd files are on a diferent dir, I get the following error: Error: RRDs::graph failed, can't parse DEF -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Can't Parse DEF error on NT
Error: RRDs::graph failed, can't parse DEF 'in0=C:/inetpub/wwwroot/mrtg/rrdtool/drmateo_e4.rrd:ds0:AVERAGE' -2 I've tried to define the path-to-rrd-file with \\, \, / and // but I always get the same error. Try this: C\\:\\Inetpub\\wwwroot\\mrtg\\rrdtool\\. Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Printing some calculated current values on a graph?
It's obvious I can use perl (or anything) instead of rrdcgi or store cpu percentages instead of the raw data but other than that? BTW, if you use GAUGE and AVERAGE to store your data, you automatically store percentage as the linux raw values are hundredth of seconds ... Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Storing snmpget results in an array
Quite easy,
try:
@var=qx(snmpwalk );
Now you have all your stuff line by line in an array named var.
To access it:
foreach (@var) {
print $_\n;
}
Or:
foreach $test (@var) {
print $test\n;
}
This way you'll get all the elements printed. Surely you can do anything you
want with this values instead of printing them ...
HTH,
Stephan
Am Dienstag, 22. Juli 2003 14:52 schrieb Stephen Cheung:
Hi all,
I've read through the manuals and mailing lists, but didn't find anything.
I'm trying to do the following:
code to get snmp data values:
$var = `snmpget -Ov myipaddress public OID.0` (1,2,etc)
I can get single values and assign it to a variable. No problems.
To get all values for that object, I can leave out the last value and get a
list
snmpget -Ov myaddaddress public OID
This command returns (say 1000) items in a list of values when run at a
command prompt.
C:\snmpperl script.pl
0
0
0
0
4
6
etc
How can I enter this list into a perl array, so that when I perform the rrd
update command, I can enter certain single element out of the array? Is
this possible?
eg rrdtool update myrrd.rrd N:$var[0]
Do I use something like snmputil perl module?
Thanks
Steve
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
--
Stephan Harren
Manager Site Operations
MFN-IS
---
Phone +49 69 90554 153
Fax +49 69 90554 111
Cell +49 173 7011126
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Problen with GPRINT
Did you try \\: ? Best regards, Stephan Am Montag, 21. Juli 2003 09:23 schrieb Michael K.: GPRINT:bitsin:LAST:Current %8.2lf %s, it works GPRINT:bitsin:LAST:Current: %8.2lf %s, but it does not work ERROR: bad format for [G]PRINT in 'Current' GPRINT:bitsin:LAST:Current\: %8.2lf %s, and it too does not work How to make, what in the deduced text the symbol was ':' -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: possible to graph the same data from different times?
Sure, just take two Datasources, and feed the second one with the data from 24 hours ago. You can easily read them from the rrd-file using rrdtool fetch. I don't know if there's a different (standard) way (don't think so), but I think this might be a good workaround. Best regards, Stephan Am Mittwoch, 2. Juli 2003 11:54 schrieben Sie: I was wondering if there was any way to graph the same data from different times on the same graph. For example, I have a 24 hour graph consisting of 2 lines. Line A is today's traffic. Line B is yesterday's traffic. Both lines are covering the same 24 hour graph, but Line B shows yesterday's values and Line A shows today's values. Is this possible? -taylor -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: X grid formatting string
Standard UNIX Formats: %a locale's abbreviated weekday name (Sun..Sat) %A locale's full weekday name, variable length (Sun- day..Saturday) %b locale's abbreviated month name (Jan..Dec) %B locale's full month name, variable length (Jan- uary..December) %c locale's date and time (Sat Nov 04 12:02:33 EST 1989) %d day of month (01..31) %D date (mm/dd/yy) %e day of month, blank padded ( 1..31) %h same as %b %H hour (00..23) %I hour (01..12) %j day of year (001..366) %k hour ( 0..23) %l hour ( 1..12) %m month (01..12) %M minute (00..59) %n a newline %p locale's AM or PM %r time, 12-hour (hh:mm:ss [AP]M) %s seconds since 00:00:00, Jan 1, 1970 (a GNU exten- sion) %S second (00..60) %t a horizontal tab %T time, 24-hour (hh:mm:ss) %U week number of year with Sunday as first day of week (00..53) %V week number of year with Monday as first day of week (01..52) %w day of week (0..6); 0 represents Sunday %W week number of year with Monday as first day of week (00..53) %x locale's date representation (mm/dd/yy) %X locale's time representation (%H:%M:%S) %y last two digits of year (00..99) %Y year (1970...) %z RFC-822 style numeric timezone (-0500) (a nonstan- dard extension) %Z time zone (e.g., EDT), or nothing if no time zone is determinable Best regards, Stephan Am Donnerstag, 15. Mai 2003 16:37 schrieb Németh László: Hi All, Could somebody help me with the possible LFM string components in -x|--x-grid option? -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Data not exact
RRA:LAST DEF:myclean=foo.rrd:clean:LAST will do. I guess the problem comes from AVERAGE consolidation. Ho often do you feed the rrd? Do you give it the timestamp? If you always give it a proper timestamp (1047670800,1047671100,1047671400 .) there will also be no problem with AVERAGEs. Try rrdtool dump to see what has been calculated in the rrd. Best regards, Stephan Am Mittwoch, 7. Mai 2003 02:52 schrieb Matthew Daubenspeck: I am trying to create a rrdtool graph to track the amount of spam and clean messages that pass through our spamassassin mail scanner. But I can't seem to get the config correct. I have some shell scripts that do all the counting, and they work just as they should when run manually. However, when the data is added to the rrd and graphed, it seems to come up short sometime. I have a single spam message and instead of the graph displaying 1, it displays like .8. Am I doing something wrong? Database: rrdtool create foo.rrd \ --step 300 \ DS:clean:GAUGE:600:0:1 \ DS:spam:GAUGE:600:0:1 \ RRA:AVERAGE:0.5:1:600 And the graph: rrdtool graph foo.png \ --imgformat=PNG \ --start=-86400 \ --title=Email Message Breakdown \ --alt-autoscale-max \ --rigid \ --width=500 \ --height=150 \ --base=1000 \ --vertical-label=Messages \ DEF:myclean=foo.rrd:clean:AVERAGE \ DEF:myspam=foo.rrd:spam:AVERAGE \ AREA:myclean#00FF00:Clean \ LINE2:myspam#FF:Spam Any ideas? Thanks for the help. -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: [rrd-users]: graphing temprature values
With what? Write the perl script? The rrd-stuff? Why don't you just start using the rrd-manual at www.rrdtool.org and ask for specific problems that you can't get along with and you can be sure to receive help. Best regards, Stephan Am Montag, 5. Mai 2003 13:02 schrieb Frank Smeby: Hi I want to make temprature graphs with RRD and i use a perl script to get the values. Could someone be so kind to help me with the scripts to do this? -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Graphing Total Bandwidth
Hi Andre, AFAIK, you've got to do this by yourself, for example in a little perl script: Collect the data you need by rrdtool fetch, add the values to the total amount you want to be graphed and put it into a rrd-database (use GAUGE as DS-Type). Then you can graph them. Every hour: collect the values for the last hour, add them and put the sum into your database for hourly graphs. Be sure to have the database have a resolution of one hour. Every day: collect the values for the last day, add them and put the sum into your database for daily graphs. Be sure to have the database have a resolution of one day. Every month: collect the values for the last month, add them and put the sum into your database for monthly graphs. Be sure to have the database have a resolution of one month. Graph them with the exact timeframe you want to have, because you don't have a higher resolution than you want to have, there will be no consolidation and the values you inserted will be graphed exactly. Another thing you can do is to fetch the stuff and write a comma-separated file, import it into excel or whatever office and do a bar-graph there (wouldn't prefer this solution). The thing is, that rrdtool can only calculate single values to be graphed. Pls let me know if anyone finds a better solution. Best regards, Stephan Andre Miller schrieb: Hi, I've tried to find an answer to this question by searching the archive - but have not been able to locate a suitable answer, sorry if its been answered before and I missed it. -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: RRD History
I do: 'RRA:LAST:0.5:1:105120' and it works fine. No negatives, no problems with performance or anything. The big advantage with this is, if you generate your graphs on the fly, maybe from a website, you can zoom into any timeframe you want to see throughout the last year. Best regards, Stephan Am Dienstag, 29. April 2003 00:39 schrieb Max Kipness: Hello All - I'm thinking of modifying some of my RRD files to include enough 5 minute samples to look back 30 - 90 days. Is it possible to do something like below?: RRA:AVERAGE:0.5:1:25920 And if so, are then any negatives to doing this? Another method I was thinking of is making a copy of each graph at midnight. I'm not sure which method would be best though. Thanks - Max -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: 95th percentile
That usually depends on how you stored your data (do you still have all 5-minute-values or did you consolidate?). IMHO the best way to do this is to write a little perl script that fetches the data out of the rrd and calculates the 95th percentile. Best regards, Stephan Am Mittwoch, 23. April 2003 14:54 schrieb Tony: I want to find out the 95th percentile of a months worth of data. Is it possible maybe using fetch somewhere to get the last months data, take out the top 5% of the data and then work out the average of the remaining 95%? Thanks in advance Tony -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: 95th percentile
Push every value into an array, sort this array descending , multiply the amount of values stored inside the array * 0.95 and take the . Hold on some minutes, I'll show you. Best regards, Stephan Am Mittwoch, 23. April 2003 15:15 schrieb Tony: All the data is 5 minute values. I can use fetch to get the data for the last month from the database, but it's all in scientific notation, how do I convert this to whole numbers? I'm currently trying to work on a perl script to work out the 95th percentile, but getting it to drop the highest 5% is a pain. Tony -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: 95th percentile
#!/usr/bin/perl
my $line;
my $value;
my $percentile95;
my @rrdfetch;
my @allvalues;
@rrdfetch=qx(/usr/local/rrdtool-1.0.39/bin/rrdtool fetch testfile.rrd AVERAGE
-s -3 -e -300);
chomp @array;
foreach $line (@rrdfetch) {
split(/\s+/,$line);
$value=($_[1] $_[2]) ? $_[1] : $_[2];
push (@allvalues,$value);
}
@allvalues=sort {$a = $b} @allvalues;
foreach (@allvalues) {
print $_\n;
}
$percentile95=sprintf(%.2f,($allvalues[(sprintf(%.0f,(@allvalues*0.95))-1)]*8/1000));
print $percentile95 KBytes\n;
This is an example where I use an rrd with in and outvalue. Which one I
choose, I decide by every line so I take the higher 5-minute-value (IN or
OUT) into final calculation. It is also possible to calculate an
IN-percentile and an OUT-percentile and than take the higher one.
HTH,
Stephan
Am Mittwoch, 23. April 2003 15:15 schrieb Tony:
All the data is 5 minute values.
I can use fetch to get the data for the last month from the database,
but it's all in scientific notation, how do I convert this to whole
numbers?
I'm currently trying to work on a perl script to work out the 95th
percentile, but getting it to drop the highest 5% is a pain.
Tony
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: 95th percentile
Ugh, small bug: last line should be KBits !!! Best regards, Stephan $percentile95=sprintf(%.2f,($allvalues[(sprintf(%.0f,(@allvalues*0.95)) -1)]*8/1000)); print $percentile95 KBytes\n; -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Double NaN with GAUGE
Hi All, I've got a problem with GAUGE. If I miss one Datapoint and it gets unknown, the next Datapoint gets unknown, too. This happens if I : /usr/local/rrdtool-1.0.39/bin/rrdtool create test.rrd --start $timestamp --step 300 DS:updown:GAUGE:300:0:1 RRA:LAST:0.5:1:105120 /usr/local/rrdtool-1.0.39/bin/rrdtool update test.rrd -t updown 1048542000:1 /usr/local/rrdtool-1.0.39/bin/rrdtool update test.rrd -t updown 1048542600:1 Then 1048542300 and 1048542600 will be NaN. Same if I use 450 as heartbeat. If I: /usr/local/rrdtool-1.0.39/bin/rrdtool create test.rrd --start $timestamp --step 300 DS:updown:GAUGE:600:0:1 RRA:LAST:0.5:1:105120 /usr/local/rrdtool-1.0.39/bin/rrdtool update test.rrd -t updown 1048542000:1 /usr/local/rrdtool-1.0.39/bin/rrdtool update test.rrd -t updown 1048542600:1 Then none of them will be NaN. How can I make it that just 1048542300 is NaN, like it should be? Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: create --step ? vs DS:heartbeat
http://people.ee.ethz.ch/~oetiker/webtools/rrdtool/manual/rrdcreate.html --step|-s step (default: 300 seconds) Specifies the base interval in seconds with which data will be fed into the RRD. heartbeat defines the maximum number of seconds that may pass between two updates of this data source before the value of the data source is assumed to be *UNKNOWN*. Best regards, Stephan when creating a database I can specify the --step parameter and I give every DS a heartbeat. Now what is the difference ? -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: cpu usage
Am Mittwoch, 12. Februar 2003 17:53 schrieb Sonja Pieper: Hi, has anyone done some logging on cpu-usage as in cat /proc/stat? I want to graph %-Values of idle/user/nice/system time the values cat /proc/stat gives you back are simply 'jiffies' counted since the computer rebooted How do I best save these values? And then how do I calculate the percent values or must I do this before storing in the rrd? Thx for any help Sonja As these are counters, you surely can use them in rrd as counters. As you see, these are 1/100 seconds, and if you put them into the rrd as counters, you'll get exactly the percentage. Example: idle counter1: 3 idle counter2: 6 Difference: 3 Divided by 300 seconds (as rrd always calculates a rate), you'll get 100% idle time (just an example, will never happen like this, just to make things easy). Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Storimg 5 min data for 2 yr
But if you graph for one year of data, this will be 105120 values on 600 pixels. What kind of values will rrdtool graph with? I tried, and from my experience, the MAX graph is higher if you keep an rra for the MAX values than the MAX graph if you don't. I guess this happens because rrd (maybe, just guessing) averages the 5-min values to appropriate information fitting into the pixel parameters. But anyway, graphs ! are ! different if you don't keep the max or keep the max data. Anyone tell me if I'm wrong. Best regards, Stephan Am Dienstag, 4. Februar 2003 08:32 schrieb Ketil Oftedahl: Andrew, I think you can get by by using only ONE RRA. If you sample tha data at 5 minute intervals and store every sample for the 2 year period there will be no need to store additional average/max values. RRA:AVERAGE:0.5:1:210240 \ This will be the raw storage of all samples for 17520 hours (730 days) RRA:AVERAGE:0.5:6:700 \ This will give you 30 minute averages for 350 hours RRA:AVERAGE:0.5:24:775 \ ...and 2 hour averages for 1550 hours RRA:AVERAGE:0.5:288:797\ ...and 24 hour averages for 19128 hours (797 days) Only this last one will cover a longer period than the raw 5-minute step RRA. If you increase the 5-minute step RRA to cover 797 days (if that's what you need) you will only need that ONE RRA. If you store every sample for the required period you will be able to create both AVERAGE and MAX graphs for any period up to the total RRA storage period with any resolution up to the sample/storage interval. (Although a 2-year graph with 5-minute step size will be rather wide ;-) Creating MAX or MIN RRAs will only be required when you are using the consolidation functionality to store data lass often than the sample interval but still want to keep the MAX/MIN values. Rgds, Ketil Andrew Werbowy wrote: So should I use MAX or not? -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Storimg 5 min data for 2 yr
It really does give you something, just because if you graph for a longer timescale rrdtool cannot graph with 5-minute-values but will keep the maxes of the 5-minute-values while calculating so you'll see a different max graph compared to the average graph. Best regards, Stephan Am Montag, 3. Februar 2003 20:17 schrieb Chris Robb: We do the same thing, except we don't do MAX for the 5-minute data. I'm not sure that gives you anything since you're polling every five minutes. The Maximum of one polling interval is whatever you get for that poll. You can cut your files down to about 3.3MB by getting rid of that. -Chris Chris Robb Indiana University Global NOC Abilene/TransPAC Network Engineer [EMAIL PROTECTED] Desk: 812-855-8604 Cell: 812-325-8199 On Mon, 3 Feb 2003, Andrew Werbowy wrote: I got request to store 5 min MRTG data for 2 yr. I know what it is not possible with MRTG, so I will have to use RRDTools. I read basic stuff about RRD and looks like I would have to do something like this: rrdtool create myrouter.rrd \ DS:input:COUNTER:600:U:U \ DS:output:COUNTER:600:U:U \ RRA:AVERAGE:0.5:1:210240 \ RRA:AVERAGE:0.5:6:700 \ RRA:AVERAGE:0.5:24:775 \ RRA:AVERAGE:0.5:288:797\ RRA:MAX:0.5:1:210240 \ RRA:MAX:0.5:6:700 \ RRA:MAX:0.5:24:775 \ RRA:MAX:0.5:288:797 note 210240 which is 2 year of 5 min stats (I think). Database would be 6.8 meg big per switch/router/server interface. What are best practices in such cases? Regards, Andrew -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Storimg 5 min data for 2 yr
Yes, you should if you want so see these values in your graph. Best regards, Stephan Am Dienstag, 4. Februar 2003 03:29 schrieb Andrew Werbowy: So should I use MAX or not? Alex van den Bogaerdt [EMAIL PROTECTED] 02/03/03 06:50PM On Mon, Feb 03, 2003 at 02:17:00PM -0500, Chris Robb wrote: We do the same thing, except we don't do MAX for the 5-minute data. I'm not sure that gives you anything since you're polling every five minutes. Try viewing an image that is doing any number of intervals per pixel, apart from one per pixel. RRDtool will take the average and NOT the maximum. Alex -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: RRD Graph not showing ??
Am Dienstag, 4. Februar 2003 17:15 schrieb J.A.J. van Belkum: dtool graph /var/www/html/img/185696009.png --start 1044370348 --end \ 1044373948 --vertical-label Memory \ --lower-limit 0 --upper-limit 400 \ DEF:fr=./rrd/185696009.2:free:AVERAGE \ DEF:us=./rrd/185696009.2:used:AVERAGE \ AREA:us:#ff:used \ STACK:fr:#ff:free Should look like: AREA:us#ff:used STACK:fr#ff:free Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: newbie: How to read RRDDUMP
Am Freitag, 31. Januar 2003 11:29 schrieb John-Paul Delaney: Hello List... The following dump fragment example of an RRA (for MAX 2hr values) has me confused (easily done!). What are the two v values /v for each row? I would expect one MAX value for that 2 hour period - please tell me my mistake. Each row should contain one incounter and one outcounter. Same for cdp_prep, I guess it stands for current datapoint preparation. Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] How does rrdtool behave if I store 5-minute-values for one year?
Hi All, what I'm asking myself is how does rrdtool behave, if I store 5-minute-values for one year and nothing else? What if I graph a timeframe of 2 months? Probably it would pick one pixel for every 2 hours. Will it use just the 2-hour-values and ignore the rest? Will it build the averages and maxes for that two-hour intervals internally and graph them? If yes, then do I really need consolidated data in my rrd? Will it find the max by every five-minute-value or will it just take the 2-hour-values and ignore the values in between? Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: How does rrdtool behave if I store 5-minute-values for one year?
So the consolidation is just good for saving disk space? Am I right, that I would just have to keep 1-year 5-minute-values and I can also get the cf MAX out of it? Best regards, Stephan Am Donnerstag, 30. Januar 2003 13:48 schrieb Serge Maandag: rrdtool uses the values the rrd holds. For the given time frame you want to graph, it will try to take the highest resolution data. If you just store 5 minute samples, it will never even think of using a 2 hours average. 2 hours average samples can only be displayed if your rrd database has an RRA that averages over 2 hours. -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: How does rrdtool behave if I store 5-minute-values for one year?
Thanks to all of you, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: newbie: MAX values not corresponding over time
Am Mittwoch, 29. Januar 2003 10:49 schrieb John-Paul Delaney: Hello List... Sorry if this has been asked before, I've searched around but didn't find/understand any answer that clarified the situation for me. I'm using directly the 'real world example' from the rrd tutorial but I'm graphing the MAX values instead of the AVERAGE ones. In the resulting graphs, the MAX values for the month are higher than those for the week (comparing the same time period on both graphs). the MAX values for the year are higher than those for the month (again comparing the same time period on both graphs). I expected the MAX values to be the same in the week, month, and year graphs - as the MAX value is not an average, and has the same value whichever way you look at it (i.e. week,month,or year). Am I completely misunderstanding the concept, or is it more likely that my own configuration is the problem? thanks /j-p. Maybe I'm getting you wrong, but most times the MAX over the year is higher than the MAX over the month. If you store a datasource with consolidation MAX, you won't lose any peak, and because of the longer period... Another point is, that in the 5-minute graph, you have 6 maximum values that go into one for the 30-minute graph. This means, that through consolidation, you lose the low values in your MAX graph. Well, if you compare the same period, the really MAXes should be the same, what if you send the code you use, so we could have a look at it... Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: newbie: MAX values not corresponding over time
Hi, up to now, can't find nothing wrong, please send also the create and update syntax and attach (not to the list but to me) the rrd-file and I'll look over it. Best regards, Stephan Am Mittwoch, 29. Januar 2003 13:28 schrieb John-Paul Delaney: Content-Type: text/plain; charset=US-ASCII Oops I see that the images have been stripped - sorry trying again. /j-p. -- Attached file removed by Ecartis and put at URL below -- -- Type: image/gif -- Size: 32k (32964 bytes) -- URL : http://www.ee.ethz.ch/~slist/pantomime/week.gif -- Attached file removed by Ecartis and put at URL below -- -- Type: image/gif -- Size: 38k (39607 bytes) -- URL : http://www.ee.ethz.ch/~slist/pantomime/month.gif -- Attached file removed by Ecartis and put at URL below -- -- Type: image/gif -- Size: 24k (24807 bytes) -- URL : http://www.ee.ethz.ch/~slist/pantomime/year.gif -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: clearing of counters on Cisco switches
Surely it will help to set a max, but btw, sometimes cisco counters jump above the interface capacity. For example, they show up that you transfer an average of 224 MBit/s over a FastEthernet-Interface. For this kind of stuff you really need to set a max of 100 MBit. Best regards, Stephan Am Dienstag, 28. Januar 2003 10:02 schrieb Serge Maandag: I regularly clear the interface counters, I do it on the command line though. That also clears the in- and outoctets. It never caused peaks in my graph. Do you have a max set for the ds's in your rrd? try rrdtool info to check. Serge -Original Message- From: Scott P. Daffron [mailto:[EMAIL PROTECTED] Sent: Monday, January 27, 2003 6:37 PM To: rrd-users@list.ee.ethz.ch Subject: [rrd-users] clearing of counters on Cisco switches RRDTOOL gurus, We have noticed that our installation of MRTG+RRDTOOL+14all.cgi shows a huge spike on our Cisco interface graphs whenever a clear counters is done on the device. This is becoming a big problem for us, as we have just implemented a new NMS which clears all counters once per day. We run MRTG with RRDTOOL and 14all.cgi, and this problem is seen in the latest versions of each. MRTG alone does NOT exhibit this behavior. I know this is an issue of the OID counter wrapping, but why is it that MRTG alone handles this and the RRDTOOL implementation does not. Is there a way to tweak RRDTOOL or 14all.cgi to better handle this wrapping situation? More info on my setup: - Switches are Cisco Cat 4006 and 5XXX - Our NMS is resetting all port counters by doing an snmpset on private.1.9.5.1.1.13.0. Most people do not believe me, but this DOES reset the ifOctets value to 0, by design. Thanks in advance... Scott Daffron Network Engineer Sentara Health Care -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Data for Specific Time
Just take a close look into the documentation of rrdtool graph. You can graph anything for a specific time, if you still have the data in your rrd-databases. Best regards, Stephan Am Montag, 27. Januar 2003 22:39 schrieb [EMAIL PROTECTED]: I currently have rrd running great on a windows 2k server and have just one question. I currently get my graphs (from cacti) just fine for the 5 min, weekly, montly, and yearly but my question is how can I get a graph say from this week that has already past or for this specific month. Sorry if this has been asked before I am new this. Thanks --Todd -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: FMAX, MIN, LAST with GAUGE data
Am Dienstag, 28. Januar 2003 09:22 schrieb Németh László: /rrdtool update test.rrd 1043739430:12 ./rrdtool update test.rrd 1043739440:14 ./rrdtool update test.rrd 1043739450:15 ./rrdtool update test.rrd 1043739460:16 ./rrdtool update test.rrd 1043739470:17 ./rrdtool update test.rrd 1043739480:18 This is just because you use step: 60. This means, there will be just one value saved every 60 seconds. You've got 6 values in 60 seconds, add them together and you'll get 92, divide it by 6 ant there will be your 15,333. MINs and MAXs just appear over n*'your-step-value' Best regards, Stephan -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: FMAX, MIN, LAST with GAUGE data
I don't know any way to avoid normalization of the counters, but what if you normalize your timestamps? If you input data every sixty seconds, it shouldn't be relevant if you use 9:00:00 or 9:00:15 as timestamp. Best regards, Stephan Am Dienstag, 28. Januar 2003 09:59 schrieb Németh László: How can I avoid normalization? I mean that it is pretty hard to find out the each steps (not stepsize) of the RRA store. I explain with an example: I have the following measurements: -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Cricket and WMI
With perl and OLE.
Example:
use Win32::OLE qw(in);
$wmi=Win32::OLE-GetObject('winmgmts:');
foreach $pstat (in $wmi-InstancesOf('Win32_LogicalDisk')) {
print $pstat-{size};
}
You can find all available WMI classes at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_classes.asp
Best regards,
Stephan
Am Montag, 27. Januar 2003 17:35 schrieb Jon Brown:
Can someone please point in to instructions on how to pull wmi information.
Jonathan Brown
--
Stephan Harren
Manager Site Operations
MFN-IS
---
Phone +49 69 90554 153
Fax +49 69 90554 111
Cell +49 173 7011126
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: FMAX, MIN, LAST with GAUGE data
Wouldn't it be easier to make the timestamp divideable by sixty?
$normalized_timestamp=int($actual_timestamp/60)*60;
Best regards,
Stephan
In Perl:
RRDs::create( clijobs.rrd, --step,$perfloginterval,
DS:jobs:GAUGE:$perfloginterval:U:U,
RRA:AVERAGE:0.5:1:10 );
my $info = RRDs::info(clijobs.rrd);
my
$firstMeas=$$info{last_update}+$$info{step}-$$info{'ds[jobs].unknown_sec'};
then the first measurement should be done at $firstMeas.
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Data for Specific Time
You should look a little closer, even if the documentation of rrdtool graph looks a little complicated. Ok, a little hint, you've got to define the datasources you wish to see. Try rrdtool graph test.png --start 01/12/03 --end 01/13/03 DEF:test= d:\mrtg\isg99sm3001\logs\isg99sm3001-1.rrd:test:AVERAGE LINE1:test#f40e0e:Test where 'test' is the datasource in your rrd-file. Change this to however your datasource is named. If you want to see two lines, you'll have two define two datasources and two lines and so on. To see how such an rrd database file looks like, try rrdtool dump d:\mrtg\isg99sm3001\logs\isg99sm3001-1.rrd There you will also find the names of your datasources. Another way to find this out is rrdtool info d:\mrtg\isg99sm3001\logs\isg99sm3001-1.rrd Just try a little and get back if you're stuck. Best regards, Stephan Am Dienstag, 28. Januar 2003 17:15 schrieb [EMAIL PROTECTED]: Ok I looked at the docs now when I run this I get C:\rrdrrdtool graph test.png d:\mrtg\isg99sm3001\logs\isg99sm3001-1.rrd --start 1/12/03 --end 1/13/03 ERROR: can't parse 'd:\mrtg\isg99sm3001\logs\isg99sm3001-1.rrd' Any thoughts -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Easy question about percents
Hi All, I need to know how tp create a rrd that does nothing but accept the values that I'm inserting, no calculation, no aggregation. The reason for that is, that I want to put in values between 0 and 100 (percentage) and I don't want rrdtool to average it. I'll keep 5-minute values for maybe one month or so. Guess: rrdtool create bla.rrd -step 300 DS:percent:GAUGE:600:0:100 RRA:LAST:1:1:8640 Am I right? Best regards, Stephan -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Weekgraphs shows only one day.
You'll have to do it like this: RRA:AVERAGE:0.5:1:576 RRA:AVERAGE:0.5:6:384 RRA:AVERAGE:0.5:24:384 RRA:AVERAGE:0.5:288:366 1st line means that you save 576 initial values. 2nd line means that you save 384 values averaged from 6 initial values. 3rd line means that you save 384 values averaged from 24 initial values. 4th line means that you save 366 values averaged from 288 initial values. (certainly, numbers of saved values are changeable) Dump your rrd with rrdtool dump rrdfile and take a look at it, this will make things more clear. If you create an rrd, it is created to have a defined number of values, they are filled up with NaNs and this number won't change any more. What you did is, you defined your AVERAGE data-source to save 288 5-minute values and that's it. HTH, Stephan HW wrote: Hi, On my website http://www.geitz.net/weather/ I try to make dayly and weekly graphs from my weather station. The day graphs are ok, but the weekgraphs only show the last day in the graph. What is wrong? here is how I made it. (seen on http://mywebpages.comcast.net/kaiminaouow/Using_Oww_and_RRDTOOL.html) init rrdtool (one year of data will be stored) rrdtool create /root/oww2.rrd -b -867000 --step 300 DS:temp1:GAUGE:600:-15:45 DS:temp2:GAUGE:600:-15:45 DS:temp3:GAUGE:600:-15:45 DS:wspd:GAUGE:600:0:140 DS:wdir:GAUGE:600:0:360 DS:baro:GAUGE:600:910:1050 RRA:AVERAGE:0.5:1:288 RRA:MIN:0.5:288:86400 RRA:MAX:0.5:288:86400 update every 20 sec: /usr/bin/rrdtool update /usr/local/share/oww/oww.rrd N:$tc1$:$tc2$:$tc3$:$wspkph$:$wdrdeg$:$barmbar1$ dayly graph: #de temp plaatjes /usr/bin/rrdtool graph /var/www/docs/weather/temp1.png -s -86400 -h 150 -w 300 -tTemp sensor 1 C \DEF:temp1=/usr/local/share/oww/oww.rrd:temp1:AVERAGE LINE2:temp1#FF:Temp1 21 /dev/null weekly graph: #de wind snelheid week /usr/bin/rrdtool graph /var/www/docs/weather/wspdweek.png -s -604800 -h 150 -w 300 -t Windspeed last 7 days \DEF:wspd=/usr/local/share/oww/oww.rrd:wspd:AVERAGE LINE2:wspd#11ff00:speed in kmph21 /dev/null Can anyone help me out? Many thanks in advance Hans-Wilem -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Watch Tool ??
What do you want to look at, why don't you write just a short perl
script that dumps the content of the rrd and parses it?
Example on linux:
#!/usr/bin/linux
@array=qx(rrdtool dump file.rrd);
chomp @array;
while $line (@array) {
**Parse the line here and do whatever you want**
}
That's it, just an idea.
HTH,
Stephan
Pierre GUYAUX wrote:
I am looking for a tool (running on Windows or Linux) to watch at a rrd
file.
I just wont to have a look on some counter values and how it changes.
Is this tool exists ??
Pierre Guyaux
Service Informatique CAFAT
Poste: 5210
émail: [EMAIL PROTECTED]
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Watch Tool ??
OOPS, little mistake,
#!/usr/bin/linux
@array=qx(rrdtool dump file.rrd);
chomp @array;
foreach $line (@array) {
**Parse the line here and do whatever you want**
}
HTH,
Stephan
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: RRD FETCH
Mauro wrote:
Hy,
i want make a script in Perl that fetch the last 15 minutes update and set it
into distinct variable.
In line command i write
rrdtool fetch ~/database/database.rrd AVERAGE -s end-15m
but with a script how can i make this and how can i put this value into 3
variabile
I think that it isn't difficult, but i'm a newbie.
#!/usr/bin/perl
use strict;
my $keys;
my @values;
@values=qx(/usr/local/rrdtool-1.0.39/bin/rrdtool fetch test.rrd AVERAGE
-s -600 -e -300);
## Now you've got the values inside the array @values
chomp @values;
## Now no more \n
foreach $keys (@values) {
print $keys\n;
}
##Shows you the content of the array
If you don't know that much about perl, you can access the array with
@values[0], @values[1], @values[2]
Best regards,
Stephan
--
Unsubscribe mailto:[EMAIL PROTECTED]
Helpmailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: How does rrd now which AVERAGE to take?
This depends on the time you choose for which the graph should be created. To me, it makes sense, to create and feed the data-sources (in your example AVERAGES) depending on the graphs that you would want to create. For example : You want to have a graph for the last twelve hours -- you should keep at least enough 5 minute samples (144+) to graph this one. You want to have a graph for the last 7 days -- you should maybe average every 30 minutes (6 samples) and keep enough 30 minute averages (336+) to graph this one. And so on ... To keep it simple, analyze what you want to graph, and have your datasources available for doing that. Easy to see, that if you just have an RRA for one day, you can't take this for a graph that's for example 4 days long. HTH, Stephan Harren Jochen Metzger wrote: Hi folks, I've been reading the rrdtutorial and looking through the docs, but still I have got a question In the example (with km's) there are to AVERAGE's when creating the rrd, how does rrd now when creating the graph which one to take. I'm stuck with this, and I didn't find the answer in the tutorial nor the docs. By the way, where do I find the faq to rrd? THX Jochen I mean this sample below = Example from the tutorial Lets take the sample from the tutorial: rrdtool create test.rrd \ --start 920804400 \ DS:speed:COUNTER:600:U:U \ RRA:AVERAGE:0.5:1:24 \ RRA:AVERAGE:0.5:6:10 and then create the graph (let's assume the data is already fed...) rrdtool graph speed.gif \ --start 920804400 --end 920808000 \ DEF:myspeed=test.rrd:speed:AVERAGE \ LINE2:myspeed#FF -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
[rrd-users] Re: Calculating average when aggregating
Good idea, but will the average be built from the first timestamp on with the first started rrd or will it be the same like with the graph ? I'm asking this, because there may be funny averages if the average will just be built from the start of the last rrd on. Best regards, Stephan Geert van der Ploeg wrote: I need to aggregate some rrds into one graph. If I do this, the aggregated graph starts with the timestamp when the last rrd was started. To get around this, i use the following RPN: ds1,UN,0,ds1,IF Now the graph seems to be ok, but the average is calculated for the whole time period. This is also a problem, because especially for the yearly graph, the average isn't as high as it should be (a lot of zero values where there should be unknowns). Does anybody know, how I get around this ? You should create another CDEF, for the average-calculating. So: 1 CDEF for making a nice graph (converting UNKNOWN values into zero's) 1 CDEF for calculating an average (leaving the UNKNOWN values as-is) And then graph the nice-graph-CDEF, and print the average-CDEF. Regards, Geert van der Ploeg Triple IT -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi -- Stephan Harren Manager Site Operations MFN-IS Germany Tel 0049 69 90554 153 Cell 0049 173 7011126 Fax 0049 69 90554 111 -- Unsubscribe mailto:[EMAIL PROTECTED] Helpmailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdminhttp://www.ee.ethz.ch/~slist/lsg2.cgi
