[Fwd: Re: [Orca-dev] hide data on plot which holds zero values...]

[Marko Schulz]

-------- Original-Nachricht --------
etreff: 	Re: [Orca-dev] hide data on plot which holds zero values...
Datum: 	Mon, 18 Oct 2004 10:26:14 +0000
Von: 	Marko Schulz <mschulz at jamba.net>
Antwort an: 	mschulz at jamba.net
Firma: 	Jamba! AG
An: 	Blair Zajac <blair at orcaware.com>
Referenzen: 	<41700F8D.9080506 at jamba.net> <41701286.9070203 at orcaware.com>



Hi,

we want to plot the cpu load of different user processes on several servers. Since we d'not know at which time, which user on which cluster 
runs, we fill the data with zeros if the user process d'not run.

We would like to indicate only if the data contains no zeros.

I have already written a script myself that scans the files and filters the columns, which contains only zeros. The problem thereby is, if on 
one day 8 user processes run and next day only 7. In result the weekly plot of the 8th user is not shown.

Do you have any idea to solve this problem?



This is the result with 'data_min U':

cpu_jadmin_008A1    Current: 14.200000    Average: 12.442500    Min: 7.180000    Max: 23.278333
cpu_jadmin_008A2    Current:  3.660000    Average:  4.010424    Min: 1.170000    Max: 10.960000
cpu_jadmin_008A3    Current:  0.860000    Average:  1.227598    Min: 0.756167    Max:  6.167833
cpu_jadmin_008A4    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_jadmin_008B1    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_jadmin_008B2    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_jadmin_008B3    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_jadmin_008B4    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_sadmin_008A1    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_sadmin_008A2    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_sadmin_008A3    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_sadmin_008A4    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_sadmin_008B1    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_sadmin_008B2    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_sadmin_008B3    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_sadmin_008B4    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000
cpu_ladmin_008A1    Current:  2.410000    Average:  2.369574    Min: 2.161833    Max:  2.645667
cpu_ladmin_008A2    Current:  0.000000    Average:  0.000000    Min: 0.000000    Max:  0.000000

This is the result with 'data_min 0.01':

cpu_jadmin_008A1    Current: 14.200000    Average: 12.442500    Min: 7.180000    Max: 23.278333
cpu_jadmin_008A2    Current:  3.660000    Average:  4.010424    Min: 1.170000    Max: 10.960000
cpu_jadmin_008A3    Current:  0.860000    Average:  1.227598    Min: 0.756167    Max:  6.167833
cpu_jadmin_008A4    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_jadmin_008B1    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_jadmin_008B2    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_jadmin_008B3    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_jadmin_008B4    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_sadmin_008A1    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_sadmin_008A2    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_sadmin_008A3    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_sadmin_008A4    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_sadmin_008B1    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_sadmin_008B2    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_sadmin_008B3    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_sadmin_008B4    Current:  nan         Average:  nan         Min:   nan       Max:  nan
cpu_ladmin_008A1    Current:  2.410000    Average:  2.369574    Min: 2.161833    Max:  2.645667
cpu_ladmin_008A2    Current:  nan         Average:  nan         Min:   nan       Max:  nan

Regards,
Marko





Blair Zajac schrieb:

> Marko Schulz wrote:
>
>> Hi,
>>
>> can anybody tell me, how to hide data on plot which holds zero values 
>> (e.g., 00000 0.0 00000 0.0 00000 0.0)?
>> Not required data should be not shown anywhere.
>>
>>
>> # ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> # G R O U P
>> # ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> group monitor-process {
>> find_files              
>> tmp/var/logs/(.*)/orca-monitor-process(?:\.(?:log\.gz|log))
>> column_description      first_line
>> date_source             column_name unix_time
>> interval                60
>> }
>>
>> # ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> # P L O T
>> # ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> plot {
>> title           %g - CPU Auslastung
>> source          monitor-process
>> data            (cpu_(?:(?:[a-zA-Z]+))_(?:[0-1][0-9][A|B][1-9]))
>> data_type       GAUGE
>> summary_format  %lf
>> plot_min        0.01
>> data_min        0.01
>> line_type       LINE1
>> y_legend        CPU Auslastung (Prozent)
>> }
>
>
> Well, the data_min and plot_min should do the trick, but what are you 
> seeing that it isn't working?
>
> The other thing to do is to have the 'data' string return a 'U' if you 
> don't want the value recorded.  Here 'U' is short for unknown.
>
> Regards,
> Blair
>