Re: [rrd-users] How to plan RRD creation from previously acquired data?
gschanuel gabriel.schan...@gmail.com 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 need to set your heartbeat to longer than the period between updates while you import the data. WHat will happen then is that when an update comes in, all the buckets from the previous update to the new one will get filled in - instead of what happens now which is that they get filled with NaN as the interval is too long for the heartbeat. After import, you should be able to tune the heartbeats back to a normal setting. Alternatively, you'll need to write a program that fills in the blank and does multiple updates spaced not more than heartbeat apart. ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] How to plan RRD creation from previously acquired data?
Hello Steve and Simon I did a script to change the data format and looks like it all worked fine. I will work later on heartbeat to ensure everything is OK. Thanks a lot for your help 2014-09-11 7:49 GMT-03:00 Simon Hobson [via RRD Mailinglists] ml-node+s937164n7582425...@n2.nabble.com: gschanuel [hidden email] http://user/SendEmail.jtp?type=nodenode=7582425i=0 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 need to set your heartbeat to longer than the period between updates while you import the data. WHat will happen then is that when an update comes in, all the buckets from the previous update to the new one will get filled in - instead of what happens now which is that they get filled with NaN as the interval is too long for the heartbeat. After import, you should be able to tune the heartbeats back to a normal setting. Alternatively, you'll need to write a program that fills in the blank and does multiple updates spaced not more than heartbeat apart. ___ rrd-users mailing list [hidden email] http://user/SendEmail.jtp?type=nodenode=7582425i=1 https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users -- If you reply to this email, your message will be added to the discussion below: http://rrd-mailinglists.937164.n2.nabble.com/How-to-plan-RRD-creation-from-previously-acquired-data-tp7582422p7582425.html To unsubscribe from How to plan RRD creation from previously acquired data?, click here http://rrd-mailinglists.937164.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=7582422code=Z2FicmllbC5zY2hhbnVlbEBnbWFpbC5jb218NzU4MjQyMnwtNDk4MDI3Mzgw . NAML http://rrd-mailinglists.937164.n2.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://rrd-mailinglists.937164.n2.nabble.com/How-to-plan-RRD-creation-from-previously-acquired-data-tp7582422p7582426.html Sent from the RRDtool Users Mailinglist mailing list archive at Nabble.com. ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
[rrd-users] How to plan RRD creation from previously acquired data?
Hello folks I have exported some data from Cacti to a CSV file (actually 300 files). Now I'm trying to add this data to a rrd. I have ordered the data in files like the one pasted here: https://gist.github.com/a9bc1e56c0c39386693f timestamp:traffic_in:traffic_out Well.. I created the rrd with this command: rrdtool create test.rrd \ --step '300' \ --start '1356998400' \ 'DS:traffic_in:GAUGE:600:0:U' \ 'DS:traffic_out:GAUGE:600:0:U' \ 'RRA:AVERAGE:0.5:1:600' \ 'RRA:AVERAGE:0.5:6:672' \ 'RRA:AVERAGE:0.5:24:732' \ 'RRA:AVERAGE:0.5:288:730' \ 'RRA:AVERAGE:0.5:8928:3' \ 'RRA:AVERAGE:0.5:107136:2' The problem is that when I update the rrd with for i in $(cat file.csv); do rrdtool update filename.rrd $i; done i get a lot (really, a lot) of NaN. I guess there is something to do with archives or step.. but I really have no idea! The file pasted on gists is just one of 300, the timestamp and frequency may be different. So, my question is: How can I create a RRD file that can store all the information pasted above, and how can I achieve that to the other 299 files? I assume that when I exported the data, they were an average already, and that's why I couldn't use COUNTER instead. Any other sugestions are very welcome Thanks in advance Gabriel -- View this message in context: http://rrd-mailinglists.937164.n2.nabble.com/How-to-plan-RRD-creation-from-previously-acquired-data-tp7582422.html Sent from the RRDtool Users Mailinglist mailing list archive at Nabble.com. ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Re: [rrd-users] How to plan RRD creation from previously acquired data?
The problem is that when I update the rrd with for i in $(cat file.csv); do rrdtool update filename.rrd $i; done i get a lot (really, a lot) of NaN. Your problem is that your data are in Scientific format; 'rrdtool update' wants them as decimals. Your file says: 1357081200:5.318666e+01:1.9346617284e+01 RRDTool wants: 1357081200:53.18666:19.346617284 Steve Steve Shipway s.ship...@auckland.ac.nz smime.p7s Description: S/MIME cryptographic signature ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users