Hello, I'm new to rrdtool. I'm trying to create a database that will record and graph data from an application. I have been using the rrdtool documentation and the RRD Wizard website to assist me. I'd like to keep track of "total sites," "deleted sites," "outdated sites, and "total users" (users will be a separate graph).
rrdtool create filename.rrd \ --step '86400' \ 'DS:TotalSites:GAUGE:172800:0:U' \ 'DS:DeletedSites:GAUGE:172800:0:U' \ 'DS:OutdatedSites:GAUGE:172800:0:U' \ 'DS:TotalUsers:GAUGE:172800:0:U' \ 'RRA:MIN:0.3:7:520' \ 'RRA:MAX:0.3:7:520' \ 'RRA:AVERAGE:0.3:7:520' \ 'RRA:LAST:0.3:7:520' \ 'RRA:MIN:0.3:1:35' \ 'RRA:MAX:0.3:1:35' \ 'RRA:AVERAGE:0.3:1:35' \ 'RRA:LAST:0.3:1:35' 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, if I create 1 month, 1 year, and 2 year graphs, will the 1 month graph automatically use the more granular RRAs (the "daily" 35-day ones as opposed to the "weekly" 10-year ones)? Here is an example `graph` command that I received from the RRD Wizard: rrdtool graph 'sites-1month.png' \ --title 'Sites, 1 Month' \ --vertical-label 'Number of Sites' \ --width '800' \ --height '300' \ --full-size-mode \ --start end-1m \ 'DEF:SitesMin=sites-new.rrd:TotalSites:MIN' \ 'DEF:SitesMax=sites-new.rrd:TotalSites:MAX' \ 'DEF:SitesAvg=sites-new.rrd:TotalSites:AVERAGE' \ 'DEF:SitesLast=sites-new.rrd:TotalSites:LAST' \ 'DEF:DeletedMin=sites-new.rrd:DeletedSites:MIN' \ 'DEF:DeletedMax=sites-new.rrd:DeletedSites:MAX' \ 'DEF:DeletedAvg=sites-new.rrd:DeletedSites:AVERAGE' \ 'DEF:DeletedLast=sites-new.rrd:DeletedSites:LAST' \ 'DEF:OutdatedMin=sites-new.rrd:OutdatedSites:MIN' \ 'DEF:OutdatedMax=sites-new.rrd:OutdatedSites:MAX' \ 'DEF:OutdatedAvg=sites-new.rrd:OutdatedSites:AVERAGE' \ 'DEF:OutdatedLast=sites-new.rrd:OutdatedSites:LAST' \ 'VDEF:SitesMinMin=SitesMin,MINIMUM' \ 'VDEF:SitesMaxMax=SitesMax,MAXIMUM' \ 'VDEF:SitesAvgAvg=SitesAvg,AVERAGE' \ 'VDEF:DeletedMinMin=DeletedMin,MINIMUM' \ 'VDEF:DeletedMaxMax=DeletedMax,MAXIMUM' \ 'VDEF:OudatedMinMin=OutdatedMin,MINIMUM' \ 'VDEF:OutdatedMaxMax=OutdatedMax,MAXIMUM' \ 'VDEF:OutdatedAvgAvg=OutdatedAvg,AVERAGE' \ 'VDEF:DeletedAvgAvg=DeletedAvg,AVERAGE' \ 'LINE1:SitesLast#00FF00:Total Sites' \ 'LINE1:DeletedLast#FF0000:Deleted Sites' \ 'LINE1:OutdatedLast#FFFF00:Outdated Sites (>=2 Years)' \ 'PRINT:SitesMinMin:%.1lf Sites Min' \ 'PRINT:SitesMaxMax:%.1lf Sites Max' \ 'PRINT:SitesAvgAvg:%.1lf Sites Avg' \ 'PRINT:DeletedMinMin:%.1lf Deleted Min' \ 'PRINT:DeletedMaxMax:%.1lf Deleted Max' \ 'PRINT:DeletedAvgAvg:%.1lf Deleted Avg' \ 'PRINT:OudatedMinMin:%.1lf Outdated Min' \ 'PRINT:OutdatedMaxMax:%.1lf Outdated Max' \ 'PRINT:OutdatedAvgAvg:%.1lf Outdated Avg' Thank you! Steve _______________________________________________ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
