[rrd-users] Import old data to rrdtool
Hicham.ElHarti at dekabank.de
Hicham.ElHarti at dekabank.de
Mon Oct 1 16:05:30 CEST 2007
Hello,
I have some text files with old monitoring data, which should be insered
to rrdtool DB and showed with graphics.
The files have this form: (timestamp art_avg art_min art_max)
===============================
1189585215 0 0 2
1189585515 0 0 3
1189585815 0 0 3
1189586115 5 0 6
1189586415 0 0 2
1189586715 1 1 3
1189587015 7 1 14
1189587315 0 0 2
1189587615 0 0 3
1189587915 0 0 2
1189588215 1 1 4
1189588515 0 0 3
1189588815 0 0 2
1189589115 0 0 1
1189589415 0 0 21
...
=================================
I created a DB for these data using:
rrdtool create test.rrd --start 1188597600\
-s 300 DS:art_avg:GAUGE:180:U:U \
DS:art_min:GAUGE:180:U:U \
DS:art_max:GAUGE:180:U:U \
RRA:AVERAGE:0.5:1:8640 \
RRA:AVERAGE:0.5:1:8640 \
RRA:AVERAGE:0.5:1:8640
========================================
I then inserted the data in form:
Timestamp:art_avg:art_min:art_max with the command rrdtool update
I tried to get the graph with: (for month september 2007)
/usr/bin/rrdtool graph test.png \
-s "00:00 09/01/07" -e "23:59 09/30/07" \
-v "ZGS Average Response Time" -w 1000 -h 450 -t " ZGS
AJA " \
DEF:art_avg=test.rrd:art_avg:AVERAGE \
DEF:art_min=test.rrd:art_min:AVERAGE \
DEF:art_max=test.rrd:art_max:AVERAGE \
COMMENT:" " \
LINE1:art_avg#00FFFF:"Average Response Time" \
LINE1:art_min#FF00FF:"Min Response Time" \
LINE1:art_min#00FF00:"Max Response Time" \
COMMENT:" \j"
But the graph is empty!!!!
When I run
rrdtool fetch test.rrd AVERAGE I get several line like:
=================================
1191242100: nan nan nan
1191242400: nan nan nan
1191242700: nan nan nan
1191243000: nan nan nan
1191243300: nan nan nan
1191243600: nan nan nan
1191243900: nan nan nan
1191244200: nan nan nan
1191244500: nan nan nan
1191244800: nan nan nan
1191245100: nan nan nan
1191245400: nan nan nan
1191245700: nan nan nan
1191246000: nan nan nan
==================================
Can you tell me please why the graphs are empty
Thank you in advance!
Cheers,
Hicham
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20071001/d9ffb2e6/attachment.html
More information about the rrd-users
mailing list