[rrd-users] graph lines differ from actual values

2014-04-07 Thread John Stile
I am using rrdtool, libdbi, and mysql to chart thermal data. I noticed the lines are sometimes a little higher than the actual data being plotted, and I would like them to match. Is there something I can change to make the graphed data match the actual data? DEF:cpuPhym=sql//mysql/host=127.0.0.1/

Re: [rrd-users] rrd dbi syntx

2014-04-03 Thread John Stile
t; On Wed, 2014-04-02 at 22:54 -0700, John Stile wrote: > Sorry for the trouble. I had a syntax error, as well as missing the * > in the date. Mysql TIMESTAMP dates required the * to force the unix > timestamp format. > > This worked for me: > rrdtool graph /home/jstile/foo.png

Re: [rrd-users] rrd dbi syntx

2014-04-02 Thread John Stile
//temperature/*date/cpu0/:avg:AVERAGE:step=600 AREA:user#66ff00:"cpu0" thank you for your help. On Wed, 2014-04-02 at 21:03 -0700, John Stile wrote: > I did try both. > rrdtool graph ./test.png --imgformat=PNG --start=-1day --end=+3hours > --width=1000 --height=600 > D

Re: [rrd-users] rrd dbi syntx

2014-04-02 Thread John Stile
I did try both. rrdtool graph ./test.png --imgformat=PNG --start=-1day --end=+3hours --width=1000 --height=600 DEF:min=sql//mysql/host=127.0.0.1/dbname=thermal/username=thermal/password=thermal//temperature/*date/cpu0:min:AVERAGE rrdtool graph ./test.png --imgformat=PNG --start=-1day --end=+3hou

Re: [rrd-users] rrd dbi syntx

2014-03-31 Thread John Stile
On Mon, 2014-03-31 at 21:19 +, Steve Shipway wrote: > >rrdtool graph > >./test.png --imgformat=PNG --start=-1day --end=+0hours --width=1000 > >--height=600 > >"DEF:min=sql//mysql/host=127.0.0.1/dbname=thermal/username=thermal/password=thermal//temperature/date/cpu0:min:AVERAGE" > > > >"LINE1

Re: [rrd-users] rrd dbi syntx

2014-03-30 Thread John Stile
On Mon, 2014-03-31 at 04:00 +, Steve Shipway wrote: > >Command: > >rrdtool graph ./test.png --imgformat=PNG --start=-1day --end=+0hours > --width=1000 --height=600 > >"DEF:min=sql//mysql/host=127.0.0.1/dbname=thermal/username=thermal/password > =thermal//temperature/date/cpu0:min:AVERAGE" "LINE

[rrd-users] rrd dbi syntx

2014-03-30 Thread John Stile
I am having a hard time finding the syntax for using a dbi with rrdtool graph. Command: rrdtool graph ./test.png --imgformat=PNG --start=-1day --end=+0hours --width=1000 --height=600 "DEF:min=sql//mysql/host=127.0.0.1/dbname=thermal/username=thermal/password=thermal//temperature/date/cpu0:min:AV

[rrd-users] loading old data

2010-11-17 Thread John Stile
I would like to start tracking the growth of my source control server, starting with data from 2007. For each repository, on a given date, I have its size and revision number, and I have a perl script to pack all the historic data into one big hash table. I am wondering if I rrdtool can be used

Re: [rrd-users] calculate change / graph change between last and last-1

2009-12-22 Thread John Stile
Is it a mistake to want to plot the difference between stored data values? On Mon, 2009-12-21 at 11:52 -0800, John Stile wrote: > I have a graph which shows the size of my server backups. > > I would like to add to the ledgend (and maybe graph) the change in size > from the last bac

[rrd-users] calculate change / graph change between last and last-1

2009-12-21 Thread John Stile
I have a graph which shows the size of my server backups. I would like to add to the ledgend (and maybe graph) the change in size from the last backup. Do I define a vdef for size,LAST and a vdef for LAST-1, then calculate a cdef of the difference then a vdef of cdef of the difference, and fina

Re: [rrd-users] gprint correct units

2009-12-21 Thread John Stile
On Fri, 2009-12-18 at 23:38 +, A Darren Dunham wrote: > On Fri, Dec 18, 2009 at 03:23:32PM -0800, John Stile wrote: > > I have a rrd with values like: 5.3304700563e+07 > > My gprint line is: > > GPRINT:backup1: %10.3lf %Sb' > > > > I'm trying to

[rrd-users] gprint correct units

2009-12-18 Thread John Stile
I have a rrd with values like: 5.3304700563e+07 My gprint line is: GPRINT:backup1: %10.3lf %Sb' I'm trying to print: 53.305 Gb but it always prints: 53.305 Mb What am I doing wrong? ___ rrd-users mailing list rrd-users@lists.oetiker.ch https://lis

Re: [rrd-users] can't update rrd with data.

2009-11-24 Thread John Stile
On Tue, 2009-11-24 at 03:19 +, A Darren Dunham wrote: > On Mon, Nov 23, 2009 at 12:38:15PM -0800, John Stile wrote: > > At the end of my backup script, if the rrd does not exist, it is created > > via the following: > > > > rrdtool \ > > create \ >

[rrd-users] can't update rrd with data.

2009-11-23 Thread John Stile
I need help to understand why my rrd won't accept data from my updates. This is to chart a number once a day. At the end of my backup script, if the rrd does not exist, it is created via the following: rrdtool \ create \ "${RRD_File}" \ --step 86400 \ "DS:size:GAUGE:87000:U:U"