[rrd-users] Re: Converting ASCII logs to RRD

[Gary Pavlik]

Shwaine,
	Sorry for the late reply....This is very easy to do.  Attack it it
two steps: 
		1) create the rrd file for your various DSs.
		2) create an update script/file for each rrdfile.

1)  Create the RRD file with the RRAs you want, something like
#!/bin/bash
rrdfile=$1
stime=$2
rrdtool create $rrdfile  --start $stime --step 1200\
  DS:ds19:GAUGE:2400:U:U \
  DS:ds20:GAUGE:2400:U:U \
  DS:ds21:GAUGE:2400:U:U \
  DS:ds22:GAUGE:2400:U:U \
  DS:ds23:GAUGE:2400:U:U \
  DS:ds24:GAUGE:2400:U:U \
  DS:ds25:GAUGE:2400:U:U \
		.
		.
		.
  RRA:AVERAGE:0.5:1:150 \
  RRA:AVERAGE:0.5:3:386 \
  RRA:AVERAGE:0.5:36:152 \
  RRA:MAX:0.5:36:152 \
  RRA:AVERAGE:0.5:72:370 \
  RRA:MAX:0.5:72:370 

2) create update script/file:
#!/bin/bash
rrdfile=$1
rrdtool update $rrdfile\
 
976238400:128516.00:444.00:128072.00:112104.00:924104.00:1036208.00:465860.0
0:
570348.00:83816.00:336660.00:17096.00:17646732.00:252972.00:16497336.00:5217
80.0
0:52.00:495224.00:39985.00:9736.00:28241.00:16310860.00:285512.00:15196796.0
0:52
6760.00:2004.00:524756.00\
 
976239600:128516.00:444.00:128072.00:111788.00:924420.00:1036208.00:465552.0
0:
570656.00:82344.00:336660.00:17104.00:17646732.00:253168.00:16497140.00:5217
80.0
0:52.00:495224.00:39985.00:9736.00:28241.00:16310860.00:285200.00:15197108.0
0:52
6760.00:2004.00:524756.00\
 
976240800:128516.00:444.00:128072.00:112100.00:924108.00:1036208.00:465848.0
0:
570360.00:83616.00:336660.00:17088.00:17646732.00:253316.00:16496992.00:5217
80.0
0:52.00:495224.00:39985.00:9736.00:28241.00:16310860.00:285160.00:15197148.0
0:52
6760.00:2004.00:524756.00


Of course generating the above data is left as an exercise for the sudent.

Hope this helps,
Gary.

-----Original Message-----
From: Shwaine [mailto:shwaine at malevolence.com]
Sent: Saturday, January 06, 2001 5:20 AM
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Converting ASCII logs to RRD



I have a game (LP Mud) which wishes to have a graphical output 
of our usage statistics. I have well over a years worth of data stored 
in ASCII files that I'd like to convert to RRD format in order to 
produce 
live webpage statistics and reduce game strain caused by people 
using the in-game commands (which are coded in a language parsed 
through the game engine so they are inheriently slower and more
resource intensive than something at shell). I can not lose this data 
(starting a new RRD file is trivial). I can not use "rrdtool update" to 
accomplish this since it will not accept a time that is before its last 
update (according to the error message that my Perl script spammed 
when I tried to convert the files using update).

Is there any way to get this data into the RRD format? If not, I will
have to move on and use another package or code my own that 
will allow me to save my old data. As I said, losing this data is not 
an option.

Thanks,
Shwaine







--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi