Databases
StackOverflow2013
Postsdbo
POcustom Ganglia cluster graphs - how to show average metric value, rather than total metric value
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POcustom Ganglia cluster graphs - how to show average metric value, rather than total metric value
    primarykey
    data
    text
    <p>How do you show mean values in custom graphs, rather than total values?</p> <p>Previously I've had success generating cluster summary graphs by creating custom .php files, as described here:</p> <p><a href="http://sourceforge.net/apps/trac/ganglia/wiki/Custom_graphs">http://sourceforge.net/apps/trac/ganglia/wiki/Custom_graphs</a></p> <p>However, up to this point, I've wanted to show total actions per second for a given metric. But now, I have some timing data where I want to show the mean (average) metric value for all cluster nodes. How is this done? With my current implementation, the generated graphs show the total time value for all nodes, which is not helpful.</p> <p>Here is the .php:</p> <pre><code>&lt;?php /* Pass in by reference! */ function graph_jmx_times_report ( &amp;$rrdtool_graph ) { global $context, $hostname, $graph_var, $range, $rrd_dir, $size, $strip_domainname; if ($strip_domainname) { $hostname = strip_domainname($hostname); } $jmx = $graph_var; $title = $jmx.' Processing Time'; if ($context != 'host') { $rrdtool_graph['title'] = $title; } else { $rrdtool_graph['title'] = "$hostname $title last $range"; } $rrdtool_graph['lower-limit'] = '0'; $rrdtool_graph['vertical-label'] = 'milliseconds'; $rrdtool_graph['extras'] = '--rigid --base 1024'; $rrdtool_graph['height'] += ($size == 'medium') ? 89 : 0; $series = "DEF:'tot_time'='${rrd_dir}/jmx_tomcat_proc_time_ms.rrd':'sum':AVERAGE" ."DEF:'fc_time'='${rrd_dir}/jmx_tomcat_freqcap_lookup_time_75.rrd':'sum':AVERAGE " ."DEF:'ro_time'='${rrd_dir}/jmx_tomcat_readonly_lookup_time_75.rrd':'sum':AVERAGE " ."DEF:'rt_time'='${rrd_dir}/jmx_tomcat_realtime_lookup_time_75.rrd':'sum':AVERAGE " ."AREA:'tot_time'#CFF1FC:'' " ."LINE2:'fc_time'#F19A2A:'Freq Cap 75' " ."LINE2:'ro_time'#66CC33:'Read-only 75' " ."LINE2:'rt_time'#CC99CC:'Realtime 75' " ."LINE2:'tot_time'#20ABD9:'Processing Time' " ; $rrdtool_graph['series'] = $series; return $rrdtool_graph; } ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USTravis Bear
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POcustom Ganglia cluster graphs - how to show average metric value, rather than total metric value
      1. USTravis Bear
      1. VTBountyStart
    2. VO
      singulars
      1. POcustom Ganglia cluster graphs - how to show average metric value, rather than total metric value
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POcustom Ganglia cluster graphs - how to show average metric value, rather than total metric value
      1. This table or related slice is empty.
      1. VTUpMod
    1. COsorry but don't work with ganglia. also having a hard time following what you are asking. But lets give it a shot, you are trying to show the average of some metric for all nodes in your cluster?
      singulars
      1. POcustom Ganglia cluster graphs - how to show average metric value, rather than total metric value
      1. USau_stan
    2. COYes, that's it exactly. I'm currently getting the total value. Normally that is just what I want, but in this case I want the average, not the total.
      singulars
      1. POcustom Ganglia cluster graphs - how to show average metric value, rather than total metric value
      1. USTravis Bear
    3. COdo you have access to the rrds you are working with? can you post the datasource and rra definitions?
      singulars
      1. POcustom Ganglia cluster graphs - how to show average metric value, rather than total metric value
      1. USau_stan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload