Re: [rrd-users] How to graph slow changing counters

2020-04-01 Thread Simon Hobson
Thorsten Erdmann wrote: > you are right (and I know) that with such a low resolution it is difficult to > draw sensefull data. But I want to understand what RRD does. I think the > aggregation is wrong: > > If I sample the data every 5 minutes (1/12h) and get a single 1kWh step in > one of th

Re: [rrd-users] How to graph slow changing counters

2020-03-30 Thread Simon Hobson
Thorsten Erdmann wrote: > I want to graph the data of my energy meter. But it is measuring only in 1kWh > raster. So with normal power usage I have every 2..4 hours a step of 1kWh. > The meter displays it’s data as kWh, so it gives e.g 600 for the absolute > counter value of 600kWh. > I sample

Re: [rrd-users] rrdtool graph: COMMENT and empty lines(lf) - comprehension question

2019-10-31 Thread Simon Hobson
Daniel Schlifka wrote: > I have a little comprehension question, i'm still struggling/fighting with > rrdtool graph. > Today i tried to create an empty line within the plotted graphs legend(to > separate two lines of text optically). > Following older ML records and StackOverflow Threads i foun

Re: [rrd-users] How to upgrade RRDtool?

2018-03-15 Thread Simon Hobson
Stage wrote: > I have a small question for you. I work as an Intern,and i got the assignment > to upgrade the monitoring solution. > Since i cannot find a guide to upgrade RRDtool on the internet. I felt urged > to ask the mailing list. > The plan is to upgrade RRDtool from 1.3.8 to 1.5.6 but i

Re: [rrd-users] Making RRDs longer

2018-01-09 Thread Simon Hobson
Benjamin Benziger wrote: > 3 years ago I've created some rrds that contain 10 minute values for 3 years. > To prevent data to get overwritten I want to enlarge the database to let's > say 10 years. How do I do that? > > rrdresize is only to change the number of rows in a specific rra? Which i

Re: [rrd-users] formatting the rrdtool graph commands/scripts

2017-11-02 Thread Simon Hobson
Andreas Schuldei wrote: > Hi, > > I am looking for inspiration for formatting my rrdtool graph commands. > given that this is some form of prgramming, i would like to extract common > parts like the preamble which is similar in many of my graphs, or format the > script so the meaning becomes m

Re: [rrd-users] Intermittent data causing stepped graphs

2017-07-27 Thread Simon Hobson
jamiedg wrote: > Recently though I've hit a problem that maybe someone can help with; > My temp sensors would normally save data at least once a min which worked > fine, but to extend battery life the newer sensors are only transmitting > data when the temp changes or at most every hour. This cau

Re: [rrd-users] Diurnal average

2017-07-15 Thread Simon Hobson
Helios Solaris wrote: >> Over how many days ? > > Over the entire database (2 years). Ouch - as already mentioned by Alex, that could be a LOT of processing and also prevents you using consolidation. > Yes, using time shift may work, but it's not really flexible when I want > to change parame

Re: [rrd-users] Diurnal average

2017-07-14 Thread Simon Hobson
Helios Solaris wrote: > Is there an easy way to plot a diurnal average? > I.e. the average from all days at 00:00, 00:01, 00:02 etc. so that I > have a plot of an average day? Over how many days ? You might be able to do it with some of the time shift functions. If, for example, you wanted to d

Re: [rrd-users] How to generate nicely formatted columns in the legend graph?

2017-04-15 Thread Simon Hobson
K. de Jong wrote: > Quick question, how can I create nice columns that won't mess up the layout > if numbers increment or decrements? Something like this: > http://martybugs.net/linux/rrdtool/images/traffic_detail.png > > I'm not trying stuff like here below, but it doesn't handle changing val

Re: [rrd-users] Quantisation issues - how do i get the math right?

2017-03-10 Thread Simon Hobson
Andreas Schuldei wrote: > I just got an idea that there might be some confusion about the word "Power". > > I am interested in both the engergy (Energie) and the power (Leistung) > output. Currently I am dealing with the power graph. Energy is the sum (or > integral over time) of the power. S

Re: [rrd-users] rrdtool fetch with a resolution != rrd_step ?

2017-03-01 Thread Simon Hobson
Marek Schimara wrote: > I'm trying to get data out of an RRD database (created with step=10) with 30s > resolution. I have read > http://oss.oetiker.ch/rrdtool/doc/rrdfetch.en.html#RESOLUTION_INTERVAL and > I'm using -start, -end timestamps aligned to 30. However I can't get rrdtool > fetch t

Re: [rrd-users] Using Granular RRA Automatically

2017-01-24 Thread Simon Hobson
Stephen R Guglielmo wrote: > If I were to do something > like the following: > > rrdtool create filename.rrd \ > --step '86400' \ > 'DS:Sites:GAUGE:172800:0:U' \ > 'DS:DeletedSites:GAUGE:172800:0:U' \ > 'DS:OutdatedSites:GAUGE:172800:0:U' \ > 'DS:Users:GAUGE:172800:0:U' \ > 'RRA:LAST:0.3:1

Re: [rrd-users] Using Granular RRA Automatically

2017-01-23 Thread Simon Hobson
Stephen R Guglielmo wrote: > With the above database, I update it once a day with four data points. > I record MIN, MAX, AVERAGE, and LAST on a weekly basis for 10 years. I > also record MIN, MAX, AVERAGE, and LAST on a daily basis for 35 days. > > My question is: Since the RRAs are not named, i

Re: [rrd-users] RRDs::graph and DEF... MIN

2016-12-02 Thread Simon Hobson
Joachim Hartmann wrote: > Hi, > I am monitoring my heating by a raspberry-pi using rrd data base: > - TMP_V = flow temperature > - TMP_R = return temperature > - WOHNZ = indoor temperature > - AUSEN = outdoor temperature > - PUMPE = circulating pump (running or not) ... > All looks fine as lpng

Re: [rrd-users] Daily consumption

2016-11-14 Thread Simon Hobson
Guillaume Betous wrote: > But do you confirm that I can update with a higher freq than de DB ? Let's > say update every 30 sec still have sense ? Yes, you can submit updates more or less as often as you want - all that happens is the intermediate data is collated until the end of the step. Hav

Re: [rrd-users] Daily consumption

2016-11-13 Thread Simon Hobson
Bram Langen wrote: > ... but for full flexibility and data analysis (such as comparing same period > year over year) I let the Raspberry Pi write the counter values once a day to > a text file. Every so often I import the CSV data into MS-Excel, allowing any > data comparison you want. You ca

Re: [rrd-users] Question regarding missing data points

2016-10-26 Thread Simon Hobson
Alex van den Bogaerdt wrote: > You are not writing points, you are writing rates which are measured > during some interval. > The rate "8" is for time 1477433700..1477434300. This is however not > allowed because of your heartbeat setting and gets lost. > > What happens if you do update at time

Re: [rrd-users] Unsubscribe

2016-10-19 Thread Simon Hobson
Jeff Letendre wrote: Absolutely nothing at all, but quoted an entire day's worth of list messages. In common with virtually all mailing lists, there's a footer on every list message. It has a link to the mailing list website (https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users) where you can un

Re: [rrd-users] Confusion about VDEF total and graph values

2016-10-14 Thread Simon Hobson
"Alex van den Bogaerdt" wrote: >> That would also work visually, but what I had in mind was not to reduce >> the >> width, but create the bars by separating them with vertical lines of the >> correct height. > > I have difficulty understanding what you describe here. I interpret him as : think

Re: [rrd-users] Confusion about VDEF total and graph values

2016-10-14 Thread Simon Hobson
humke wrote: > I can see where you are going with this. I want the total surface of 24 bars > to be the same as the surface for the 1 bar. So AVERAGE would be the correct > CF choice here, because only that CF would give me the same surface. I will > try this. Correct > I could (or maybe even

Re: [rrd-users] Confusion about VDEF total and graph values

2016-10-14 Thread Simon Hobson
Bram wrote: > You may want to consider splitting the databases. That's a "six of one, half a dozen of the other" choice really. In this case, it's not too likely that you'd be wanting to add or abandon data sources, but I'd probably also use separate files. The main reason for splitting them w

Re: [rrd-users] Confusion about VDEF total and graph values

2016-10-13 Thread Simon Hobson
humke wrote: > By the way, I am not sure why you don't see the code with the variables. > It's there when I lookup the post via the forum solution on oetiker's > rrdtool website: Same here - I see it on the website, but not in the emails I got from the list. My guess is that it got stripped in

Re: [rrd-users] COMPUTE DS & altering existing rrd file

2016-09-28 Thread Simon Hobson
I wrote: > Can I confirm I have this right ... > > If I want to have a DS showing if the measured value was above some threshold > (in this case, network traffic above say 80%) I can use a compute DS like : > DS:pc80:COMPUTE:in,,GT > > So if the "in" value is greater than the threshold val

[rrd-users] COMPUTE DS & altering existing rrd file

2016-09-21 Thread Simon Hobson
Can I confirm I have this right ... If I want to have a DS showing if the measured value was above some threshold (in this case, network traffic above say 80%) I can use a compute DS like : DS:pc80:COMPUTE:in,,GT So if the "in" value is greater than the threshold value ( here) then pc8

Re: [rrd-users] montor size of dir

2016-09-19 Thread Simon Hobson
On 19 Sep 2016, at 16:24, Martin Friberg wrote: > ok i use GAUGE for temp mayby wrong? Sorry, my mistake - gauge is correct. ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

Re: [rrd-users] montor size of dir

2016-09-19 Thread Simon Hobson
Martin Friberg wrote: > if i run `du -sm /path/to/dir// |sed -e s/". "//g|awk '{$1=$1 ;printf $1}' > > i get the size of that directory in mb all good > but how do i go about and create a rrd file i know how to create one for > tempereature but i dont think that would work here :) > > should

Re: [rrd-users] Counting the number of times a threshold has been reached and print that number, trouble with TOTAL

2016-07-26 Thread Simon Hobson
Alexander Topolanek wrote: > But the result is weird... the line for hotdays is working, showing 1's for > all days above 30, but the total is 1.296000 M, not 14... Did you look to see what you get if you divide 1296000 by 14 ? You'll find it's quite close to 86400 which is the number of secon

Re: [rrd-users] does rrdtool support https or ssh?

2016-06-30 Thread Simon Hobson
Yamei Feng wrote: > Does rrdtool have the option of enabling secure protocols (E.g. HTTPS, LDAPS, > SSH, etc) for sending data securely over the network? I go through the > documentation on http://oss.oetiker.ch/rrdtool/, but does not find any > information about that. No it doesn't. Rrd does

Re: [rrd-users] Changing the start and end times for daily (step=86400) consolidation?

2016-06-27 Thread Simon Hobson
mmclure wrote: > Is there any way to specify that daily consolidation should occur between > times that are not midnight UTC? AFAIK it's a known issue with no easy solution. I think the only workarounds have involved fiddling with the timezone to fudge things. _

Re: [rrd-users] RRD Graph Data

2016-06-09 Thread Simon Hobson
Leandro Costa wrote: > Hi Alex, I'm not graphing 24h. I've made a test with a single point in time, > same start and and date/time ( 20160608 18:00 ). > The graph shows one value while the rrdfetch gives me other one. And what resolutions do you have consolidations for, and what consolidations

Re: [rrd-users] only getting nan values

2016-05-27 Thread Simon Hobson
Jim Sher wrote: > RRD creating scripts here: (NOTE! I've been chopping and changing the scripts > since yesterday when I composed the original email I sent earlier to see if I > could jiggle something loose :-) - no luck so far) > > #! /bin/bash > > rrdtool create data.rrd \ > --step '60' \ >

Re: [rrd-users] only getting nan values

2016-05-26 Thread Simon Hobson
Jim Sher wrote: > I'm using cron to run a script every 5 minutes to get some values and update > the RRD files and then draw the graphs. > My script to populate the RRAs in the RRD: > But when I view the graphs (all of them are like the one below), all the > values are not numbers (nan). Two

Re: [rrd-users] Adding data in the past

2016-03-09 Thread Simon Hobson
Olivier Nicole wrote: > I am stuck with aan annoying issue with rrdtool. > > I want to add data in the past but cannot figure how to do so. You can't That's a design feature, not a bug. > So far, I have only added data now, but I want to reconstruct an history > from data gathered from an olde

Re: [rrd-users] [Fwd: Suppress graph output on on empty data (e.g. min=0, max=0)]

2016-03-08 Thread Simon Hobson
Karsten Siegmund wrote: > As to 2), I found this post to the list from 2007 > https://lists.oetiker.ch/pipermail/rrd-users/2007-September/013179. It would help if you didn't miss the html off the end ;-) > I guess no further solution has been forthcoming for that problem since > 2007? Probably

Re: [rrd-users] [FORGED] Re: Installing rrdtool on Linux machine

2016-03-02 Thread Simon Hobson
azeddine bezzir wrote: > The machine i am trying to install rrdtool on it, is not mine, it belong to > my company, so i cannot install another OS on it, or change any configuration. > I want to manually install the tool There's a conflict there - you aren't allowed to change anything, but you

Re: [rrd-users] Installing rrdtool on Linux machine

2016-02-29 Thread Simon Hobson
I wrote: > azeddine bezzir wrote: > >> In fact i downloaded the latest rrdtool package rrdtool-1.5.5, and tried to >> run the steps decribed in the below url: >> >> http://www.cyberciti.biz/faq/howto-install-rrdtool-on-rhel-linux/ > > Did you look at the date on that ? JULY 28, 2008 which is

Re: [rrd-users] Installing rrdtool on Linux machine

2016-02-29 Thread Simon Hobson
azeddine bezzir wrote: > In fact i downloaded the latest rrdtool package rrdtool-1.5.5, and tried to > run the steps decribed in the below url: > > http://www.cyberciti.biz/faq/howto-install-rrdtool-on-rhel-linux/ Did you look at the date on that ? JULY 28, 2008 which is over 7 years old. You

Re: [rrd-users] Installing rrdtool on Linux machine

2016-02-29 Thread Simon Hobson
azeddine bezzir wrote: > I want to install rrdtool on a Linux machine, in order to store some > statistics files and generate graphs accordingly. > > In fact, it's the first time i am using this tool, and i am unbale to install > it, could you support please? > > The OS version is: > > Red H

Re: [rrd-users] Why is this happening?

2016-02-23 Thread Simon Hobson
Mike_K wrote: A message without a question ! I can **GUESS** from the subject line that **SOMETHING** isn't happening as you would expect. You haven't said that that something is so it's all guesswork. I would GUESS that you aren't expecting the gaps in the graph, is that correct ? Why, well w

Re: [rrd-users] Help with: Input from a file in the RRD Graph

2016-02-18 Thread Simon Hobson
Mats Gustavsson wrote: > I have a Perl script that creates a .png file with the graph. So far so good. > In the Graph I have the function "HRULE:22#00" that works just fine. > > Now I want to make the value 22 flexible. I want it be be read from a > external file. > So when I just change th

Re: [rrd-users] RRDTOOL Update with script in string

2016-01-16 Thread Simon Hobson
Tony Mountifield wrote: >> # Get the file >> Utmp=$( < /home/pi/net/devices.csv ) >> >> # Get everything after the 12th ',' >> Utmp=$(Utmp#*,*,*,*,*,*,*,*,*,*,*,*,) > > Always dangerous to type suggestions on the fly without testing! > (been there, done that) > > I think you mean ${ ... } not

Re: [rrd-users] RRDTOOL Update with script in string

2016-01-15 Thread Simon Hobson
maxmax20 wrote: > rrdtool update /home/pi/net/net.rrd N:'cut -d, /home/pi/net/devices.csv -f13 > | cut -d: -f2': to get the first value out of the csv file, but it seems > that it won't work. As suggested, put echo in front of it - and possibly pipe the output through hexdump. One thought,

Re: [rrd-users] RRA of unaltered data

2015-11-25 Thread Simon Hobson
Thomas Nilsson wrote: > 1. Is there a way to get the values I add to show up unaltered in the RRA? >Tried with LAST, AVERAGE, MIN and MAX in the RRA declaration. > > 2. How are the values in my RRA calculated? These together must be one of the most frequently asked questions, to which th

Re: [rrd-users] Graph NaN Values

2015-11-23 Thread Simon Hobson
"Manzke, Udo" wrote: > Result is an Error: “RPN Stack Underflow”. Do anyone know what’s wrong? DEF:rtMills=/icmp.rrd:icmp:AVERAGE \ CDEF:rt=rtMills,1000,/ \ CDEF:unknownpos=rt,UN,INF,UNKN,IF,/ \ OK, lets break that down. rt -> puts rt on the stack UN -> take rt off the stack and leaves true

Re: [rrd-users] graph question

2015-11-23 Thread Simon Hobson
Steve Shipway wrote: > OK, so your RRD file is correctly configured to allow from -20 to +50 as > valid values for the internal/external DS. Well something doesn't tie up then, the original question shows -55 to +125 as the allowed range. ___ rrd-us

Re: [rrd-users] graph question

2015-11-21 Thread Simon Hobson
s pascal wrote: > But when i create the graph, the temperature curve shows only positive > temperature and not negative temperature. > > When the temperature is going under 0 C, the curve is blank then become > visible when temperature is positive. I can't see anything wrong with either comma

Re: [rrd-users] reduce graph generation times

2015-11-08 Thread Simon Hobson
Alex van den Bogaerdt wrote: some very good advice. The only thing I can add is to, if you have the storage, the --lazy option. That way, while each graph will take the same time to create, it only needs to be created once. So if (for example) you have a page with several graphs of the same thi

Re: [rrd-users] Incorrect MAX total from consolidated cacti graph

2015-10-29 Thread Simon Hobson
Steve Shipway wrote: > Unfortunately, your RRD file and the commandline are being generated > internally by Cacti, ... You can get Cacti to show you the command it used to draw a graph - useful for debugging. Also be aware that I've had "issues" getting Cacti to use the correct def. IIRC (it

Re: [rrd-users] Incorrect MAX total from consolidated cacti graph

2015-10-28 Thread Simon Hobson
jbhowe wrote: > I have a cacti graph which is a consolidation of 34 graphs of online user > counts. A primary purpose of this graph is to identify peaks in user counts. > My problem is that the SUM of the MAX values is incorrect unless I constrain > the timeline of the graph to the minute contain

Re: [rrd-users] rrdtool memory usage and the Raspberry Pi

2015-10-19 Thread Simon Hobson
Rafal Gwizdala wrote: > Maybe the file size growth is expected to be parabolic - i think every RRA is > 'global' - it covers all the data sources. So when you're adding DS and RRA > pair you're actually adding N RRAs where N is number of data sources. At > least this is how i understood the co

Re: [rrd-users] Local maximum and minimum

2015-10-15 Thread Simon Hobson
Philip Gwyn wrote: > Hello, > > I have a 1-wire setup in my attic. I log temperature and humidity and > generate daily/weekly/monthly graphs. I use a modified temps.pl from Thierry > Hugue. > > What I would very much like is to graph the local maximum and minimum > temperature. This would

Re: [rrd-users] Temperature diff colors

2015-09-09 Thread Simon Hobson
Martin wrote: > I´m wondering if anyone has a code example for showing diffrent colors in a > graph depending on temperatue like this, if it above +0 and up the color is > red and if its below -0 its blue ? Here's one I did that does "light red" when things are close to the limit, and "full o

Re: [rrd-users] Stacking

2015-08-11 Thread Simon Hobson
Devante Vargas wrote: > I am working on creating a graph for my ping script. It collects, min, max > and average response times. I have added the ::STACK for the AREA after the > first AREA is defined. Problem is it adds the next two on top and moves it up > a notch, e.g. Min response time is

Re: [rrd-users] updating rrd file with ping min, max and avg times in milliseconds

2015-08-10 Thread Simon Hobson
Devante Vargas wrote: > I created the rrd file using the following parameters: > > rrdtool.exe create latency.rrd > --start now > DS:response:GAUGE:600:U:U > RRA:MIN:0.5:12:8760 > RRA:MAX:0.5:12:8760 > RRA:AVERAGE:0.5:12:8760 > > I am trying to update it but having problems getting the fol

Re: [rrd-users] scheduling RRD graph upates on a windows 2008 R2 platform

2015-07-16 Thread Simon Hobson
Brent Barr wrote: > I've gone to a system that uses a python file to generate the graphs on the > fly. Request the HTML page and it takes 5+ seconds to go get the data and > generate the charts for that page. Means I only generate charts a few times > a week, and that the data is always the

Re: [rrd-users] graph is empty, not sure what I am doing wrong

2015-07-07 Thread Simon Hobson
Devante Vargas wrote: > I then connect to XenApp and launch a session and runt he update command > using the following: > > c:\Perl\site\lib\auto\RRDs\rrdtool.exe update > f:\PSscripts\Common\Get-FarmData\DASHBOARD\DEV_Accounts\SessionState.rrd > N:2:1:1:0:0:0 > > Once its updated How many

Re: [rrd-users] How to find a grafics error?

2015-06-14 Thread Simon Hobson
Peter A. Menzel wrote: > I actually found some missing update values - that means not every second a > new set of values. > > Now I intent to tune the heartbeat value to 5 instead of 2, > and step size of 1 remain constant... > So missing 1, 2 or 3 measures will not generate an *unknown* value

Re: [rrd-users] How to find a grafics error?

2015-06-11 Thread Simon Hobson
Peter A. Menzel wrote: > Here is the setup script: > > rrdtool create AgroFire.rrd --step 1 \ > DS:KesselTemp:GAUGE:2:U:U \ > ... > RRA:AVERAGE:0.5:1:864000 \ Can you be certain that you provide an update *every* second ? You have a step size of 1, and a heartbeat value of 2. That means that

Re: [rrd-users] How to find a grafics error?

2015-06-10 Thread Simon Hobson
Peter A. Menzel wrote: > my cgi output for the monthly periode seems to have errors (in detail: see > attached image). > As you can see on http://hk1.famenzel.at/cgi/hk1.cgi the output for the last > week ("letzte Woche") is ok (continued graphs for the temperatures), but > shown interrupted i

Re: [rrd-users] OpenWrt + Collectd + RRDTool

2015-06-10 Thread Simon Hobson
Aizad Fauzi wrote: > I've installed these three components and my graph is working perfectly. > I create a symlink of the PNG to the root of my www folder so that I can > easily view the graph directly. > However, in order for the graph to be updated, I need to log-on to the router > and view f

Re: [rrd-users] Graphing inconsistencies graphing different time slices

2015-06-08 Thread Simon Hobson
Munroe Sollog wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Very interesting. Thank you for clarifying it. > > My problem is, as you can see from the graphing function, I am arbitrarily > taking numerous rrds > and adding them together to get a cumulative graph. While some of

Re: [rrd-users] Graphing inconsistencies graphing different time slices

2015-06-08 Thread Simon Hobson
I wrote: > So when you draw a graph over a longer time period, depending on the > consolidation, you may see your maximum value go up (with these made up > figures, by 1/3) when you add max values together. To add ... I had something similar for some of my servers - I wanted a maximum mail qu

Re: [rrd-users] Graphing inconsistencies graphing different time slices

2015-06-08 Thread Simon Hobson
Munroe Sollog wrote: > I have an inconsistency when I graph the same event over 10days versus 48hrs. > I would expect > because I am using MAX that the peak on the 48hr graph and the 10day graph > for the *same* event > would still read the same number. However, the peak for Sunday noon on th

Re: [rrd-users] Getting an overview of many statistics...

2015-05-29 Thread Simon Hobson
Peter Valdemar Mørch wrote: > Looking at average and standard deviation is a possibility, but most of my > users (and I) really have no good intuitive feeling for what standard > deviation really "means". +1, I don't either > I've seen that smokeping does something interesting, see e.g. > >

Re: [rrd-users] Concatenate 2 RRD without overlap or sum

2015-03-25 Thread Simon Hobson
topgunx1 wrote: > Sorry but I'm not so expert in rrd for implementing what you have suggested > me. Then treat it as an opportunity to learn ! > Is it possible for you correct my script (I know you are very busy!)? No, but I'll get you started. See http://oss.oetiker.ch/rrdtool/doc/rrdgraph_r

Re: [rrd-users] Concatenate 2 RRD without overlap or sum

2015-03-20 Thread Simon Hobson
On 20 Mar 2015, at 15:45, topgunx1 wrote: > I should draw a graphic with the values (IN/OUT) of 2 NICs. > I wouldn't like that graphs overlap or sum > I need to placed RX1 above the RX2 (starting from Y-0), > and TX1 above TX2 (newly starting from Y-0). You mean, at some point T you switched t

Re: [rrd-users] Min Max Values

2015-03-12 Thread Simon Hobson
jr1 wrote: > I use > DS:i1:GAUGE:60:-10:100 \ > RRA:AVERAGE:0.5:1:86400 > I need 3 Number for each DS avverage, min, max for a periode of 60 sec. > > How to create the Database? DS:i1:GAUGE:60:-10:100 \ RRA:AVERAGE:0.5:1:86400 RRA:MINIMUM:0.5:1:86400 RRA:MAXIMUM:0.5:1:86400 (or could be

Re: [rrd-users] Found a old .rrd

2015-03-12 Thread Simon Hobson
Martin wrote: > So i found a old .rrd db is there a way to find out the settings used to > create it, so i can graph it again ? rrdtool info file.rrd All the information should be in there. ___ rrd-users mailing list rrd-users@lists.oetiker.ch https

Re: [rrd-users] Drawing daily Min/Max graph from a source with UN values

2015-02-01 Thread Simon Hobson
Alexander Topolanek wrote: > I'm fetching data from my radio weather station and put them into graphs. A > graph that shows the temperature over the day, and follow up graphs that show > min, max and average temps from the previous days. > > Unfortunately some times the transmission from the w

Re: [rrd-users] Updates once a day

2015-01-30 Thread Simon Hobson
Simone Morandini wrote: > With this setup, when I issue an "rrdtool fetch" command, shouldn't I see one > row per day? I have the update script running since a week now, but I still > see one sigle row of output. Yes, but did you specify a period and resolution ? It's possible that it's picki

Re: [rrd-users] Inserted value becomes NaN

2015-01-15 Thread Simon Hobson
Jon August wrote: > I do an update like this: > > rrdtool updatev filename.rrd N:1102 > > What am I doing wrong? One update does not create a value in the database - it merely sets a "known point", and for the very first update, all data up to that point is unknown. You need to make repeated

Re: [rrd-users] perfdata not correctly parsed ?

2015-01-12 Thread Simon Hobson
Nicolas - rrdtool wrote: > I then modified the plugin so that it outputs raw values, the new perfdata is > the following : > > '/mnt/disk1'=4354426724352B;5110741642076;5220650064486;0;5495421120512 > > But now, the graph doesn't recognize the values (too big ?), as it says > "-nan'. I'd be

Re: [rrd-users] Measuring rain from weatherstation

2014-12-08 Thread Simon Hobson
Alex van den Bogaerdt wrote: > As before: don't write to RRDtool unless the value tipped over to the next > number. There won't be spikes. The amount of rain will be divided by the > amount of seconds since the last update. So use derive data type, write 0.5 (or any larger value that's accumu

Re: [rrd-users] Measuring rain from weatherstation

2014-12-07 Thread Simon Hobson
Alex van den Bogaerdt wrote: > After getting above mentioned stuff right, you could try to increase the > accuracy of your rainfall meter. It involves remembering values read from > it. An example works best: > > At time 09:55 you get "<1". > At time 10:00 you get "<2". > Upto and including

Re: [rrd-users] How to plot clustered column graph ?

2014-11-16 Thread Simon Hobson
Joel HATSCH wrote: > Everybody knows that kind of representation, but now question is how to > draw this with RRDgraph ? I'm not aware of a command to make columns > narrower and group graphs side by side. It can't be done, or at least, not without a lot of fudging around. You'd probably be bett

Re: [rrd-users] Start graph at 1st of current month?

2014-11-03 Thread Simon Hobson
> but what if i want my graph to start at the 1st of the current month? > all i could come up with was something like this: >> start=midnight 01.11 > which will indeed start the graph at the 1st of November, but not very handy > as i have to modify the RPN for every concurrent month. Use "start=${

Re: [rrd-users] be more selective with datasources to plot

2014-10-13 Thread Simon Hobson
Alceu R. de Freitas Jr. wrote: > In most of cases, only part of those datasources will have interesting > results (~8% of datasources will have values near zero). I would like to > filter only the datasources that have a value greater than a threshold. Fetch isn't a useful tool for this. Use g

Re: [rrd-users] not being able to get exactly updates made

2014-10-08 Thread Simon Hobson
Alceu R. de Freitas Jr. wrote: > Am I not following the concepts of RRDTool Yes > or there is possibly a bug with RRDTool::OO? No bug - it's working as designed. See "Rates, normalizing and consolidating" on this page http://www.vandenbogaerdt.nl/rrdtool/

Re: [rrd-users] find top 10 in > 4000 rrd files

2014-10-02 Thread Simon Hobson
Rob Hassing wrote: > I am measuring the bandwidth usage of over 4000 ports in a network using > sFlow. > > The sFlow daemon I use generates a rrd file for each port. > > So I have over 4000 rrd files named: x.x.x.x-Y.rrd > Where x.x.x.x is the ip address of the host and y is the portindex nu

Re: [rrd-users] Bar graph by hour, day, month

2014-09-29 Thread Simon Hobson
bsua...@free.fr wrote: > My water meter delivers one pulse per liter consumed. I have a script that > counts the pulses (raspberry and piface). > > Periodically I want to store in the RRD database the number of pulses. > The first solution is to periodically store the number of impusions since

Re: [rrd-users] Bar graph by hour, day, month

2014-09-29 Thread Simon Hobson
Bruno Suarez wrote: Some clarification is needed, it could be that you are using terms that mean one thing to you and something else to us. > I want to make graphs of water consumption. > I have a counter that is incremented for every liter of water consumed, > this counter will be stored in th

Re: [rrd-users] Can I stuff an RRD with data after-the-fact?

2014-09-17 Thread Simon Hobson
> Do you run Nagios (or anything similar) ? For some of my stats, I twigged > that Nagios already collected some performance stats (but not all I wanted) - > it just needs a bit of scripting to drop that data into a file and process it. http://nagios.sourceforge.net/docs/3_0/perfdata.html _

Re: [rrd-users] Can I stuff an RRD with data after-the-fact?

2014-09-16 Thread Simon Hobson
On 16 Sep 2014, at 19:17, Alan McKay wrote: > On Tue, Sep 16, 2014 at 11:00 AM, Simon Hobson wrote: >> That will work just fine *IF* none of the data in your file is older than >> data in the RRD file AND all the timestamps in the file are in increasing >> order. With

Re: [rrd-users] Can I stuff an RRD with data after-the-fact?

2014-09-16 Thread Simon Hobson
Alan McKay wrote: > For various reasons I want to collect data in my own logfile formatted thus : > > :data1:data2 > > And then when I want to see a graph, copy that over to another host and feed > it > into an RRD file, then graph it from there. That's OK. > But of course in doing so I get

Re: [rrd-users] How to plan RRD creation from previously acquired data?

2014-09-11 Thread Simon Hobson
gschanuel wrote: > I guess there is something to do with archives or step.. but I really have > no idea! The problem is the heartbeat (plus the format already mentioned). Your new RRD is expecting data spaced by (at most) 600 seconds - while your data is spaced a LOT wider than that. You'll ne

Re: [rrd-users] Empty sections in AREA on graph, but values in database

2014-08-28 Thread Simon Hobson
Thomas Brinkmann wrote: > this is working :-) Good news > so this must really be a internal math and rounding issue. I'm thinking that unless your graph has *exactly* one pixel per data point, then there is data manipulation going on. Say a pixel takes in a little over a data point - lets sa

Re: [rrd-users] Empty sections in AREA on graph, but values in database

2014-08-28 Thread Simon Hobson
Out of interest, what happens if you simply add a cdef for stufe*100 (CDEF:stufe2=stufe,100,*) and plot a line for that ? I'd expect to see an almost straight line at 100, 200, or 300. Remove the plot commands for the other stuff and the autoscaling should show (say) 99 to 101 or something like

Re: [rrd-users] How to calculate desired value?

2014-08-23 Thread Simon Hobson
spock wrote: > I tried: > CDEF:heattime2=heat_flag,900,*,60,/ \ > VDEF:totalheattime=heattime2,AVERAGE' > GPRINT:totalheattime:"Total\: %2.2lf h \n"' > but I get wrong results. I probably have to do the calculation completly > different. > > Can anyone help me out here? > > I

Re: [rrd-users] max / min values not precise? Bug?

2014-08-23 Thread Simon Hobson
spock wrote: > I have difficulties to interpret the graph created with the parameters below > (I omitted some lines, but relevant data should be there). > > > > The graph shows > - one line with high resolution data > - o

Re: [rrd-users] Issue: only the first value gets into the database

2014-08-10 Thread Simon Hobson
spookyx wrote: > rrdtool update wazers_ro.rrd > N:${USERS[1]}:${USERS[2]}:${USERS[3]}:${USERS[4]}:${USERS[5]}:${USERS[6]}:${USERS[7]}:${USERS[8]}:${USERS[9]} Create a short test script that does updates with fixed values - both for time and inputs. We have absolutely no idea when you ran the co

Re: [rrd-users] CDEF,RPN, no decimal constant possible?

2014-07-10 Thread Simon Hobson
Alex van den Bogaerdt wrote: > try "4,342944" I assume that would upset the parser as the 4 and 342944 would appear as separate arguments. Other than that, do the calculation in the data collection script - that would be my preference, process whatever the raw input is and convert to "real" u

Re: [rrd-users] Can't graph anything from populated rrd

2014-07-07 Thread Simon Hobson
Victor Mercado wrote: > rrdtool.create('%s' % rrd_input_file, '--start', 'now', '--step', '120', >'DS:Jitter:GAUGE:5000:U:U', >'DS:PacketLossPerc:GAUGE:5000:U:U', >'RRA:AVERAGE:0.5:1:1440', >'RRA:AVERA

Re: [rrd-users] api for iterating over single rows in a rrd file

2014-07-04 Thread Simon Hobson
Daniel Pocock wrote: >> From a technical perspective, if rrdtool provided such an API: > - it would make programming easier for people accessing data in this way > - it could be optimized for efficiency (e.g. the IO subsystem would be > reading 4KiB of data from each file at a time, the iterator

Re: [rrd-users] Fetch the time of the first entry

2014-07-02 Thread Simon Hobson
Alex van den Bogaerdt wrote: > The other option is to modify the documentation to match the source. How about changing it to "first value in the RRA", plus a note along the lines of : "The value returned will always be the timestamp of the last completed entry in the RRA minus the timespan cov

Re: [rrd-users] Fetch the time of the first entry

2014-07-01 Thread Simon Hobson
Steve Shipway wrote: > You seem to be misunderstanding how RRDTool works. > > Remember that, after every update of an RRA, the oldest value is thrown away > to make room for the new one. So, the 'first' time (the timestamp of the > oldest bucket in the RRA) will increase every time you update

Re: [rrd-users] Fetch the time of the first entry

2014-07-01 Thread Simon Hobson
Alex van den Bogaerdt wrote: > As already explained, "rrdtool first" gives you the first available slot. Looks like the documentation is misleading then : http://oss.oetiker.ch/rrdtool/doc/rrdfirst.en.html says : > The first function returns the UNIX timestamp of the first data sample > entere

Re: [rrd-users] Fetch the time of the first entry

2014-07-01 Thread Simon Hobson
Steven Sim wrote: > When I create the RRD, I am forced to give the --start as one step > BEHIND my actual update. > > So let's say my data starts at midnight 1st July, I am forced to create a RRD > with --start time at 11:45 30th of June. > > data starts -> 1st July 00:00:00 <-- first data e

Re: [rrd-users] Fetch the time of the first entry

2014-07-01 Thread Simon Hobson
Steven Sim wrote: > BUT when I use rrdtool first in an attempt to get the time of > the first entry, I get a Unix time stamp which is one entire month EARLIER > than the first entry in the file. > > And each time I do update, rrdtool first returns a DIFFERENT > number. With each update, do

Re: [rrd-users] Fetch the time of the first entry

2014-07-01 Thread Simon Hobson
Steven Sim wrote: > my rrdtool first command keeps returning different timing after > each rrdtool update. > > Why is that so? > > Shouldn't it ALWAYS return the Unix time stamp for the first entry? It's not a function I've used ... The docs say it should return the first value entered. Onc

  1   2   3   4   5   6   7   >