RE: Summing values from database

Glad it works.

There is still development going on.  It seems to
be in spurts though.

Patches are accepted.

Alan

-----Original Message-----
From: Stephen Carville [mailto:[email protected]]
Sent: 23 May 2006 02:40
To: Cricket List
Cc: Edmonds, Alan
Subject: Re: [cricket-users] Summing values from database


Edmonds, Alan wrote:
> You could do it with a COMPUTE datasource.  You 
> might also accomplish what you want with a STACKED
> graph type.  You could stack Active on top of IDLE
> (or vice versa) and that would should show a total.

Thanks.  STACK works fine.  Turns out my major problem was a small error 
in the documentation:

view   "Traffic Flow"
    elements = "ifInOctects, ifOutOctets"

Will not work.  Take out the comma in "elements":

view   "Traffic Flow"
   elements = "ifInOctects ifOutOctets"

and life is beautiful :-).

BTW, is cricket still under active development?  If I add something si 
it worth my while to submit patch?

(I'm cc;ing you on this because my postings keep bing moderated for some 
reason.

> Alan
> 
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of Stephen
> Carville
> Sent: 19 May 2006 06:12
> To: Cricket List
> Subject: [cricket-users] Summing values from database
> 
> 
> I have a process that sample about 16 status variables related to 
> database connectivity and stores them in the rrd.  For example I have 
> track the active and idle connections to two different databases.  What 
> I'd like to do is add active to idle to make total and then display 
> total and active on the same graph.  Something like:
> 
> datasource  flood-active
>      ds-source   =   "exec:0:%home-dir%/bin/tomcat-db-conn.pl %server% 
> '%tomcat-url%'"
>      desc        =   "Active Connections to FLOOD."
>      rrd-ds-type     =   GAUGE
> 
> datasource  flood-idle
>      ds-source   =   "exec:1:%home-dir%/bin/tomcat-db-conn.pl %server% 
> '%tomcat-url%'"
>      desc        =   "Idle Connections to FLOOD."
>      rrd-ds-type     =   GAUGE
> 
> datasource flood-max
>      ds-source   =   "exec:2:%home-dir%/bin/tomcat-db-conn.pl %server% 
> '%tomcat-url%'"
>      rrd-ds-type = GAUGE
> 
> datasource flood-min
>      ds-source   =   "exec:3:%home-dir%/bin/tomcat-db-conn.pl %server% 
> '%tomcat-url%'"
>      rrd-ds-type = GAUGE
> 
> datasource flood-total
>      ds-source = "flood-idle, flood-active, +"
> 
> It seems that it should be straightforward but I cannot figure it out. 
> mtargets looked promising but it seems to only allow for one combined 
> value per graph.
> 


-- 
Stephen Carville <[email protected]>
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602


-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642