Re: [cacti-user] Template graph to plot current raw values instead of average

Daniel Rossi wrote:
> On 30/07/2008, at 3:27 AM, Reinhard Scheck wrote:
>>>
>>> Typo, its the total connections for the lifetime of the server online
>>> and yes its a counter. ActiveConnections is a gauge. It's storing the
>>> values in the rrd like 1.9 instead of the real value which is 100  
>>> even
>>> when running via command line. So its something ive done wrong in
>>> cacti, or the rrd is being built incorrectly for what i want it to  
>>> do ?
>> Please be aware of the fact, that commonly COUNTERs have to be read  
>> as "value
>> per second". To get "value per minute", you'll have to multiply by  
>> 60. To get
>> "value per interval" (where "interval" is assumed to be 300),  
>> multiply by 300.
>> That's a guess, for sure.
> 
> So that number i need to display by multiplying the interval, if it  
> got 1.9 as a value for instance and i had entered manually 100 into  
> rrdtool update for that current timestamp, what would i need to times  
> then to get the 100 value for instance.
> 
> I guess we just want to graph connections within the given minute,
Fine. Than use (create) a CDEF "Make Data per minute" that multiplies the 
CURRENT_DATA_SOURCE by 60
> or  
> given data update, rather than working out connections per second  
> however that would also be nice to graph.
>>>
>> It would be nice to see the debug for the data source to see, if all  
>> CFs are
>> present.
> 
> Here it is sorry
> 
> /usr/bin/rrdtool create \
> /var/www/web4/web/rra/localhost_activeconnections_154.rrd \
> --step 300  \
> DS:ActiveConnections:GAUGE:600:0:10000000000 \
> DS:MaxConnections:GAUGE:600:0:10000000000 \
> DS:TotalConnections:COUNTER:600:0:10000000000 \
> DS:ActiveClients:GAUGE:600:0:10000000000 \
> DS:MaxClients:GAUGE:600:0:10000000000 \
> DS:TotalClients:COUNTER:600:0:10000000000 \
> DS:ActiveSubscopes:GAUGE:600:0:10000000000 \
> DS:MaxSubscopes:GAUGE:600:0:10000000000 \
> DS:TotalSubscopes:COUNTER:600:0:10000000000 \
> RRA:AVERAGE:0.5:1:500 \
> RRA:AVERAGE:0.5:1:600 \
> RRA:AVERAGE:0.5:6:700 \
> RRA:AVERAGE:0.5:24:775 \
> RRA:AVERAGE:0.5:288:797 \
> RRA:MIN:0.5:1:600 \
> RRA:MIN:0.5:6:700 \
> RRA:MIN:0.5:24:775 \
> RRA:MIN:0.5:288:797 \
> RRA:MAX:0.5:1:500 \
> RRA:MAX:0.5:1:600 \
> RRA:MAX:0.5:6:700 \
> RRA:MAX:0.5:24:775 \
> RRA:MAX:0.5:288:797 \
> RRA:LAST:0.5:1:600 \
> RRA:LAST:0.5:6:700 \
> RRA:LAST:0.5:24:775 \
> RRA:LAST:0.5:288:797 \
That's fine. No issue here
> 
> Clearly i have no idea how rrd works, i wish it was a simple sql query  
> syntax though.
In this case you would have to deal with consolidation on your own, graphing 
would be left to you and stuff. Please understand, that cacti relies on rrdtool. 
It uses most of rrdtool features but inherts all of its limitations

Reinhard