perfparse-users — Problems using PerfParse

Re: [Perfparse-users] Newbie's question

[Ben C. <bcl...@pe...>]

Horváth Tamás wrote:

> 3. In Chapter 4 there is: "Please use InnoDB tables ...". What does InnoDB
> mean? Hoiw can I configure MySQL to satisfy this requirement?

Sorry I missed the second part of your question.

You have to download the 'max' version of MySQL.  Nothing else is required.

Ben



-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php

Re: [Perfparse-users] Newbie's question

[Ben C. <bcl...@pe...>]

Hi Tamas,

These are good questions, expect the FAQ to include these answers soon!

I'll see if I can add anything to Yves reply :)

> 3. In Chapter 4 there is: "Please use InnoDB tables ...". What does InnoDB
> mean? Hoiw can I configure MySQL to satisfy this requirement?

MySQL uses many table types.  The most advances is InnoDB tables. 
(Although not quite the fastest).  I chose these because they offer 
significant advantages:

- Referential Integrity.
- Transactions.
- Concurrent Backup.

These protect the database from corruption.  For instance if a program 
crashes.  They also bind the data together.  You cannot, for instance, 
delete a 'host' if there is still valid data for this host.  Therefore 
avoiding hundreds of meg of data you cannot see or delete without 
specialist coding :)

They also offer concurrent backup.  'Hot Backups'.  You can dump the 
contents of the database without stopping PP.  Even if that dump takes 
many days, you always get a snapshot of how the database was at the 
start of the backup.

More information on InnoDB tables from http://www.innodb.com.


> 6. How PerfParse graph "data", if there is no data?

Any plugin not providing valid graphable (performance) data will not be 
shown to select.  In the future we may change this to list all 
host/service but mark them as containing no data.  If the users wish this :)


> I Whish Everybody Merry Christmas!

Your self as well,

Ben

-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php

Re: [Perfparse-users] Newbie's question

[Yves <yme...@pe...>]

> Hi List!
>
> Now I use Nagios 1.2 on Debian Woody 3.1 and Nagios-plugins 1.4.0-alpha=
3. I
> read about some "Chart-tool" and I would like to implement PerfPrase, a=
fter
> migrating to Nagios 2.0.
>
>
> Before my work I have some unanswered questions (I read through Install=
ation
> guide, digging in FAQs, etc.):
>
> 1. I like "Method 4 : Ask Nagios to write into a pipe". Is it compatibl=
e
> with Nagios 2.0?

Not tested. But I coded it for easier migration to nagios 2.0 in the futu=
re :)

> 2. There is a "perfparse_nagios_pipe_command.pl" in Chapter 5| Method 4=
 of
> the Installation Guide. Because I'm not a programmer it would be very g=
ood
> for me, if I'll be able to download this script. An example is OK, mayb=
e I
> can modify it, or revrite in a shell script (I know it better then Perl=
).
> How can I get this script?

Download perfparse and find it in the config/ directory.

> 3. In Chapter 4 there is: "Please use InnoDB tables ...". What does Inn=
oDB
> mean? Hoiw can I configure MySQL to satisfy this requirement?

 contrib/mysql_create.sql is a script that does it for you.
What does InnoDB mean ? I don't really know, but ask Ben or read the Mysq=
l documentation :)

> 4. In Chapter 4 there is: "Create a database ... and a user in that
> database. NEXT, use the mysql_create script in the contrib directory to
> create the necessary tables within the database. Eg, with user 'bob' an=
d
> database 'nagios': $ cat mysql_create.sql | mysql -u bob -p -D nagios"
>
> This example do exactly what I have to do, or according to the text bef=
ore I
> run this example I have to create a database and a user in that databas=
e? If
> this latter case is true how can I do this?

You have to create a user and a database yourself.
This is a lack of the documentation.

CREATE DATABASE perfparse;
GRANT ALL ON perfparse.* TO 'perfparse'@'%' IDENTIFIED BY 'password';

Then you have a database called "perfparse", a user "perfparse" with a pa=
ssword "password".

cat mysql_create.sql | mysql -u perfparse -p -D perfparse


> 5. Is PerfParse capable to graph Check performance data, or just the Pl=
ugin
> performance data?

Both
One is perfchart and the other is perfgant.

> 6. How PerfParse graph "data", if there is no data?

I think there is a text to say "no data" or something similar. I don't re=
member what was
done.

> 7. How Perfparse handle plugin timeouts?

This is the job of nagios.
When there is a plugin timeout, nagios does not get the data, and does no=
t send data to
perfparse.

> Sorry, if my questions was silly, but I'm not a programmer and not a
> Database administrator.

I'm not a dba either.
Ben and others may give a better answer about database questions :)

> Thank you very much!
>
> I Whish Everybody Merry Christmas!

You too :)
Yves


--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- Perfparse   - http://perfparse.sf.net/                           -

[Perfparse-users] Newbie's question

[<zs...@ax...>]

Hi List!

Now I use Nagios 1.2 on Debian Woody 3.1 and Nagios-plugins 1.4.0-alpha3. I
read about some "Chart-tool" and I would like to implement PerfPrase, after
migrating to Nagios 2.0.


Before my work I have some unanswered questions (I read through Installation
guide, digging in FAQs, etc.):

1. I like "Method 4 : Ask Nagios to write into a pipe". Is it compatible
with Nagios 2.0?

2. There is a "perfparse_nagios_pipe_command.pl" in Chapter 5| Method 4 of
the Installation Guide. Because I'm not a programmer it would be very good
for me, if I'll be able to download this script. An example is OK, maybe I
can modify it, or revrite in a shell script (I know it better then Perl).
How can I get this script?

3. In Chapter 4 there is: "Please use InnoDB tables ...". What does InnoDB
mean? Hoiw can I configure MySQL to satisfy this requirement?

4. In Chapter 4 there is: "Create a database ... and a user in that
database. NEXT, use the mysql_create script in the contrib directory to
create the necessary tables within the database. Eg, with user 'bob' and
database 'nagios': $ cat mysql_create.sql | mysql -u bob -p -D nagios"

This example do exactly what I have to do, or according to the text before I
run this example I have to create a database and a user in that database? If
this latter case is true how can I do this?

5. Is PerfParse capable to graph Check performance data, or just the Plugin
performance data?

6. How PerfParse graph "data", if there is no data?

7. How Perfparse handle plugin timeouts?

Sorry, if my questions was silly, but I'm not a programmer and not a
Database administrator.

Thank you very much!

I Whish Everybody Merry Christmas!

Tamas!

[Perfparse-users] perfparse-0.104.4 broken... some news

[Yves <yme...@pe...>]

Hi developers, hi all

In my previous mail about perfparse-0.104.4ym1, I forgot to say that if y=
ou install that
version, you should subscribe to perfparse-devel mailing-list. Next mails=
 about
perfparse-0.104.4ymX versions will be only on perfparse-devel.

After 2 days running perfparse-0.104.4ym1, I found another bug : periodic=
 cleanup enters
an infinite loop if you already have compressed files in the dirs to clea=
n up.
1st day : compression of log files -> creation of .gz files
2nd day : infinite loop due to those .gz files.

This is why I wanted to wait at least 3 days before the release of 0.104.=
5.

I fixed that bug and you can find 0.104.4ym2 on
http://pagesperso.laposte.net/ymettier/perfparse-devel/perfparse-0.104.4/=
.
I think (and I hope) that 0.104.4ym2 is now stable but we need time to be=
 sure.
So we will wait at least 3 days again before the release of 0.104.5.
You won't have it for Christmas, sorry :)

Following mails about 0.104.4ymX (and any development versions) on perfpa=
rse-devel
mailing-list.

Merry Christmas to everybody,
Yves

--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- Perfparse   - http://perfparse.sf.net/                           -

[Perfparse-users] Fix for perfparse-0.104.4 available

[Yves <yme...@pe...>]

Hi,

As you probably know, a broken release of perfparse, with version number =
0.104.4, was
released this morning. That version contains some unfinished work on log =
rotation,
compression and removal of log files (logs, drop files and output files f=
rom
"file_output" storage module). Ben misunderstood me about that work and p=
robably thought
that it would not impact users, so he released 0.104.4.

I finished that work today, and made some tests and it looks correct now.
You can download 0.104.4ym1 from
http://pagesperso.laposte.net/ymettier/perfparse-devel/perfparse-0.104.4/

To test that new release in good conditions, I need 3 days to see if the =
files I watch
are compressed/uncompressed/removed as expected. So perfparse-0.104.5 wil=
l not be
released before Thurday 23th, and only if my tests are successful.

Ben also told me about minor changes, so you may find some other 0.104.4y=
mX before
Thursday on my perfparse unofficial web site :)

I apologize here for the trouble caused by releasing 0.104.4 too early. A=
nd I can now
say that you should not loose data with 0.104.4. However, because it does=
 not work as
expected, consider that version as unsupported.

Yves

--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- Perfparse   - http://perfparse.sf.net/                           -

[Perfparse-users] Version 0.104.4, please read!

[Ben C. <bcl...@pe...>]

Further note on version 0.104.4

Please Read!

If you use the perfparsed part of PerfParse, used for instance for the 
Pipe method:  Please DO NOT use 0.104.4.  Please wait for next version.

Regards,

Ben.

-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php

[Perfparse-users] New version, 0.104.4, please read.

[Ben C. <bcl...@pe...>]

Monday morning is not the time to make release announcements, some error 
is inevitable!

The correct details of release available here:

http://wiki.perfparse.org/tiki-view_forum_thread.php?comments_parentId=10&forumId=2

Note:-

If you are using the storage_file_output used to store Nagios data into 
the file database.  (NOT MySQL)  Please do not use this version. 
Another will be releases soon.

Regards, Ben.



-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php

[Perfparse-users] New version, 0.104.4

[Ben C. <bcl...@pe...>]

There is a new version, 0.104.4.

Details available on announce forum:

http://wiki.perfparse.org/tiki-view_forum_thread.php?comments_parentId=5&topics_offset=1&forumId=2

Ben.

-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php

[Perfparse-users] Help needed.

[Ben C. <be...@cl...>]

Dear users,

We need some help with documentation.  This is a plea for any users who 
would like to contribute to PerfParse.

If you can do any of the following:

- Proof-read documentation.

- Provide documentation for DBA tasks.  Including dumping and restoring 
PerfParse, which would include a deletion of InnoDB table space.  If you 
can provide a script, even better :)

- Provide indepth reports of setup examples you have found to work which 
may have been of use to other users.

- Translate documentation.

We would be very interested in hearing from you.  Any work completed 
will of course be credited in your name if you so wish.

Kind regards,

Ben Clewett.

Re: [Perfparse-users] drz

[Ben C. <be...@ro...>]

I think these emails mean that our sister mailing forum on 
wiki.perfparse.org is now sending it's post to us on this mailing list :)

Thanks to Flo for getting this to work, I couldn't get it to work!

Ben



wk-...@pe... wrote:

> drz
> dfjh
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
> 

[Perfparse-users] drz

[<wk-...@pe...>]

drz
dfjh

[Perfparse-users] test

[<wk-...@pe...>]

test
test

[Perfparse-users] test

[wiki-help-forum <wik...@ww...>]

Test posting, please ignore.

Re: [Perfparse-users] low bound thresholds

[Ben C. <be...@cl...>]

Hi Rene,

There is a supported mechanism.  Unfortunately not fully supported yet 
by perfparse.

The plugins have a warning/critical format where by a range can be 
selected.  Therefore any threshold can be defined.  As well an inner or 
outer range.

This is explained in more depth here:

http://nagiosplug.sourceforge.net/developer-guidelines.html#THRESHOLDFORMAT

Your plugin will need to be edited to correctly use the theses.  You 
will also have to wait until work on PerfParse has been completed. 
Hopefully soon.

I hope this is of help,

Ben Clewett.


rene grabner wrote:
> Hi all,
> 
> I wonder how to inform perfparse about lower bound thresholds.
> Monitoring load, disk usage or temperatures are no issues, because the
> values for warn and crit are in normal operation greater than the actual
> value.
> 
> But, when perfparse processes perfdata of check_swap (reports how many
> bytes are free) or a plugin that checks fan speeds, the values for warn
> and crit are less than the actual value. On the perfparse overview page
> they are marked as critical.
> Especially for a plugin that returns fan speeds it is hardly possible to
> invert the semantics from within the plugin to make perfparse behave
> correctly.
> Maybe, I am just missing something?!
> 
> thanks for ideas and best regards,
>  Rene
> 
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
> 

[Perfparse-users] low bound thresholds

[rene g. <rgr...@fr...>]

Hi all,

I wonder how to inform perfparse about lower bound thresholds.
Monitoring load, disk usage or temperatures are no issues, because the
values for warn and crit are in normal operation greater than the actual
value.

But, when perfparse processes perfdata of check_swap (reports how many
bytes are free) or a plugin that checks fan speeds, the values for warn
and crit are less than the actual value. On the perfparse overview page
they are marked as critical.
Especially for a plugin that returns fan speeds it is hardly possible to
invert the semantics from within the plugin to make perfparse behave
correctly.
Maybe, I am just missing something?!

thanks for ideas and best regards,
 Rene

RES: [Perfparse-users] Prune performance fata on graph presentation

[Paulo A. G. F. <pau...@pr...>]

Ben,

Read my answers below.

Paulo Afonso Graner Fessel
Administrador de Ambiente e Sistemas UNIX
pau...@pr...
OWT
Fone: +55 (11) 3038-6554
Fax: +55 (11) 3038-6508
http://www.primesys.com.br
=20
=20
=20
=20

> I echo Yves comments about how to discard data and still get=20
> what you need.  For example, if you take only 1 in 10 points,=20
> you may miss some vital spike in the graph.

Get mean values off any data series will tend to remove spikes present
among the values you get. This is valid both for nature-generated and
computer-generated data. ;)

> What is more important to you, to look good or be accurate?

Yves already pointed out that for long range time graphs they don't need
to be that accurate. So I think that they should look good AND take less
time to be generated. Nowadays this is also an issue, as graphs for a
long period take a long time to appear.

> For instance a weeks data will be stored as a single value. =20
> Or what ever time period you like.  Each time period would be=20
> represented by storage of the average, max, min and standard=20
> deviation of that time period.

This would be great. This would allow us to generate graphs faster, with
a nice look AND provide some clues about spikes that may have
disappeared in the process of mean calculations. We could even include a
link for plotting the full data whenever the STDDEV is above a specified
value. ;)

> On the graph you would select either the full data, or a=20
> channel of summary data.=20

> Would this be an answer for you?

Oh yes, surely yes.

> I have been trying to work on a new database format which is=20
> smaller and faster for full data.  But this is going slowly. =20
> Would you and other members of this list prefer if we get the=20
> summary data working first?

If it's possible to make it faster than the "new and improved database
scheme", yes. A big yes, really.
=20
[]'s and thanks a lot for PerfParse.

Re: RES: [Perfparse-users] Prune performance fata on graph presentation

[Yves <yme...@pe...>]

>> I will probably work on that soon, but when you have
>> something like 1500 points in one day, what point will you take ?
>> When you draw a graph for a long period, you don't care about
>> details. What details to remove ? Do you want to see average
>> values for every day in one month ? The max per day ? The min
>> ? Draw them all ? Draw other values (std deviation... ) ?
>
> As a physicist by formation, I really understand your worries. But IMO
> the solutions are:
>
> * For a monthly graphic, pick up the max, medium and min values for the
> day and plot them.
> * For a yearly graphic, do the same for monthly values.

I had the same ideas. Good that we have the same opinion :)

[...]

> Yes, you don't need too much precision (and thus my suggestion to use
> mean values) but you do need graphics that do look good. Don't take me
> wrong, but MRTG has been doing this from years! I think it won't byte i=
f
> we take a look into MRTG's solutions to make PerfParse code better and
> meet end user expectations.

mrtg and rrdtool :)
Yes, of course. It is not possible to make some elegant CGI with mrtg or =
rrdtool in
perfparse and that's the reason why we are reinventing the wheel :)
Well, it takes time to reinvent the wheel, and before that, Ben works on =
the database
schema.
Then, with summary data, you will have the values you want in the databas=
e, and just
have to plot them. When the new database is ready, this will be easy to d=
o :)


>
>> > *	Allow export of metrics to CSV files, so they can be treated
>> > outside of PerfParse using software like LabPlot or OpenOffice
>> > Spreadsheet.
>>
>> I suggest a tool that does it on the command line. And if
>> wanted, front-ends of course :)
>
> I think it's better integrate this in PerfParse front-end from the
> beginning. IMO, PerfParse's public are not only geeks but also their
> managers. ;)

I will explain my point of view to make things clear. I begin with the co=
nclusion : of
course, we integrate this as soon as possible in a front-end :)
In fact, we will do a lot of code :
- take the data from many possible sources (mysql database, other databas=
es, perfparsed
and maybe other sources)
- draw a graph or make CSV documents
- ...
If we put everything in a graphic tool, we have problems. For example, pe=
rfchart.cgi can
draw only from a mysql source. You have to rewrite it if you take another=
 database or if
you want to draw other values.
So we need a library that does a lot of things, but not the presentation.
Then we make a command line tool that use the library. For tests and geek=
 users.
And then, (this is the conclusion), as soon as possible, we make the fron=
t-end for real
users and managers.
When somebody else (like Flo) wants to write another front-end, he writes=
 the front-end
only, not everything :)
I hope I was not too boring with my explanations :)

Yves


--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- Perfparse   - http://perfparse.sf.net/                           -

Re: [Perfparse-users] perfparse.cgi

[Ben C. <bcl...@pe...>]

Dear Krzemiński

This is an interesting one, and I don't know how it happened.

You version in your database is '0,15'.  It should be '0.15'. 
Internally this is converted to a double:

double version = atof(version)

So '0.15' -> 0.15  but '0,15' -> 0.00

Can please enter:

mysql> UPDATE perfdata_registry SET rvalue = '0.15' WHERE rkey = 
'pp/database/version';

Would you have any idea how this got like this to begin with?  Any 
information you have would be very useful.

The code which sets this is:

void setVersion(double version)
{
	char s[10];
	sprintf(s, "%.2lf", version);


Can you write a test program on your local UNIX box and let me know what 
this does on your system?

int main() { double d = 0.15; printf("%.2lf", d); return 1 }

I note this is using the 'lf' GNU extension.  Which GNU takes to mean 
'long float'.  Could your system take this to mean 'local float'?  If 
you change this to "%.2f" does this fix the problem?

Regards,

Ben


Krzemiński Krzysztof wrote:

> Hello,
> 
> I've problem with using perfparse.cgi.
> When I open this address: http://host/nagios/cgi-bin/perfparse.cgi, I 
> got following information:
> 
> Database Schema version is incorrect.
>  Current Version: 0.00, Required Version: 0.15.
>  Consider upgrading with:
>  perfparse-db-tool --update
> 
> I used this comman few times, but more importently in mysql logs, there 
> is information about requested query to database about perfparse version:
> 
> 041216 13:45:58  102457 Connect     perfparse@localhost on perfparse
> 102457 Query       SELECT rvalue,ctime from perfdata_registry WHERE host 
> = 'dummy' AND rkey = 'pp/database/version'
> 
> This log information are correct (user and database name) and when I use 
> above query to database I got this:
> 
> rvalue  ctime
> 0,15    2004-12-14 13:00:38
> 
> so it's look like database schema version is correct.
> 
> Anyone have such problem? How can I solve this problem or pass over this 
> version checking?
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
> 


-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php

Re: [Perfparse-users] perfparse.cgi

[Yves <yme...@pe...>]

On the command line, run "perfparse.cgi --show_config"
Do the parameters look good ?
If not, check the config file location.

No better idea for now.

Yves

> Hello,
>
> I've problem with using perfparse.cgi.
> When I open this address: http://host/nagios/cgi-bin/perfparse.cgi, I
> got following information:
>
> Database Schema version is incorrect.
>   Current Version: 0.00, Required Version: 0.15.
>   Consider upgrading with:
>   perfparse-db-tool --update
>
> I used this comman few times, but more importently in mysql logs, there
> is information about requested query to database about perfparse versio=
n:
>
> 041216 13:45:58  102457 Connect     perfparse@localhost on perfparse
> 102457 Query       SELECT rvalue,ctime from perfdata_registry WHERE hos=
t
> =3D 'dummy' AND rkey =3D 'pp/database/version'
>
> This log information are correct (user and database name) and when I us=
e
> above query to database I got this:
>
> rvalue  ctime
> 0,15    2004-12-14 13:00:38
>
> so it's look like database schema version is correct.
>
> Anyone have such problem? How can I solve this problem or pass over thi=
s
> version checking?
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users=
.
> Discover which products truly live up to the hype. Start reading now.
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>
>


--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- Perfparse   - http://perfparse.sf.net/                           -

Re: [Perfparse-users] Prune performance fata on graph presentation

[Ben C. <bcl...@pe...>]

Paulo,

Thanks for the feedback.  Large time range graphs are in need of work.

I echo Yves comments about how to discard data and still get what you 
need.  For example, if you take only 1 in 10 points, you may miss some 
vital spike in the graph.

What is more important to you, to look good or be accurate?

We have an option we are going to implement soon where by we store 
summary data.  This should look good and be accurate.

For instance a weeks data will be stored as a single value.  Or what 
ever time period you like.  Each time period would be represented by 
storage of the average, max, min and standard deviation of that time period.

On the graph you would select either the full data, or a channel of 
summary data.

Would this be an answer for you?

This data is populated when the data is first stored.  Therefore no 
extra tools are needed and the graph should be a lot faster, not slower.

I have been trying to work on a new database format which is smaller and 
faster for full data.  But this is going slowly.  Would you and other 
members of this list prefer if we get the summary data working first?

Regards,

Ben.




Paulo Afonso Graner Fessel wrote:

> Hello, Ben.
>  
> We have noticed that the graphs for PerfParse don't look good when we 
> take into account extended periods of time - for example, when we make 
> graphs that cover months of collected data. Thus, I think it would be 
> interesting implement these features:
>  
> 
>     * Let the user specify how many data points he wants in order to
>       graph a metric;
>     * Make PerfParse calculate automatically how many data points are
>       neccessary to make a graph that is both precise and looks good;
>     * Allow export of metrics to CSV files, so they can be treated
>       outside of PerfParse using software like LabPlot or OpenOffice
>       Spreadsheet.
> 
> I have other suggestions that are related to user interface, but first I 
> will take a look on the PHP interface for PerfParse. I pretend to 
> install a development server tomorrow to finally be able to implement 
> 0.104 with MySQL 4.1.
>  
> []'s
> Paulo
>  
> *Paulo Afonso Graner Fessel*
> /Administrador de Ambiente e Sistemas UNIX/
> pau...@pr... <mailto:pau...@pr...>
> OWT
> Fone: +55 (11) 3038-6554
> Fax: +55 (11) 3038-6508
> http://www.primesys.com.br <http://www.primesys.com.br/>
>  
>  
>  


-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php

RES: [Perfparse-users] Prune performance fata on graph presentation

[Paulo A. G. F. <pau...@pr...>]

Yves, look at my answers below.

Paulo Afonso Graner Fessel
Administrador de Ambiente e Sistemas UNIX
pau...@pr...
OWT
Fone: +55 (11) 3038-6554
Fax: +55 (11) 3038-6508
http://www.primesys.com.br
=20
=20
=20
=20

> -----Mensagem original-----
> De: per...@li...=20
> [mailto:per...@li...] Em nome de Yves
> Enviada em: quinta-feira, 16 de dezembro de 2004 10:42
> Para: per...@li...
> Assunto: Re: [Perfparse-users] Prune performance fata on=20
> graph presentation
>=20
> > *	Let the user specify how many data points he wants in order to
> > graph a metric;
>=20
> I will probably work on that soon, but when you have=20
> something like 1500 points in one day, what point will you take ?
> When you draw a graph for a long period, you don't care about=20
> details. What details to remove ? Do you want to see average=20
> values for every day in one month ? The max per day ? The min=20
> ? Draw them all ? Draw other values (std deviation... ) ?

As a physicist by formation, I really understand your worries. But IMO
the solutions are:

* For a monthly graphic, pick up the max, medium and min values for the
day and plot them.
* For a yearly graphic, do the same for monthly values.

> What are the real needs here ?
> We need to think on that.
>=20
> > *	Make PerfParse calculate automatically how many data points are
> > neccessary to make a graph that is both precise and looks good;
>=20
> For short periods, graphs are both precise and look good.

Right.

> For long periods, you don't need precision.

Yes, you don't need too much precision (and thus my suggestion to use
mean values) but you do need graphics that do look good. Don't take me
wrong, but MRTG has been doing this from years! I think it won't byte if
we take a look into MRTG's solutions to make PerfParse code better and
meet end user expectations.

> > *	Allow export of metrics to CSV files, so they can be treated
> > outside of PerfParse using software like LabPlot or OpenOffice=20
> > Spreadsheet.
>=20
> I suggest a tool that does it on the command line. And if=20
> wanted, front-ends of course :)

I think it's better integrate this in PerfParse front-end from the
beginning. IMO, PerfParse's public are not only geeks but also their
managers. ;)

[]'s
Paulo

[Perfparse-users] perfparse.cgi

[<krz...@at...>]

Hello,

I've problem with using perfparse.cgi.
When I open this address: http://host/nagios/cgi-bin/perfparse.cgi, I 
got following information:

Database Schema version is incorrect.
  Current Version: 0.00, Required Version: 0.15.
  Consider upgrading with:
  perfparse-db-tool --update

I used this comman few times, but more importently in mysql logs, there 
is information about requested query to database about perfparse version:

041216 13:45:58  102457 Connect     perfparse@localhost on perfparse
102457 Query       SELECT rvalue,ctime from perfdata_registry WHERE host 
= 'dummy' AND rkey = 'pp/database/version'

This log information are correct (user and database name) and when I use 
above query to database I got this:

rvalue  ctime
0,15    2004-12-14 13:00:38

so it's look like database schema version is correct.

Anyone have such problem? How can I solve this problem or pass over this 
version checking?

Re: [Perfparse-users] Prune performance fata on graph presentation

[Yves <yme...@pe...>]

> *	Let the user specify how many data points he wants in order to
> graph a metric;

I will probably work on that soon, but when you have something like 1500 =
points in one
day, what point will you take ?
When you draw a graph for a long period, you don't care about details. Wh=
at details to
remove ? Do you want to see average values for every day in one month ? T=
he max per day
? The min ? Draw them all ? Draw other values (std deviation... ) ?

What are the real needs here ?
We need to think on that.

> *	Make PerfParse calculate automatically how many data points are
> neccessary to make a graph that is both precise and looks good;

For short periods, graphs are both precise and look good.
For long periods, you don't need precision.

> *	Allow export of metrics to CSV files, so they can be treated
> outside of PerfParse using software like LabPlot or OpenOffice
> Spreadsheet.

I suggest a tool that does it on the command line. And if wanted, front-e=
nds of course :)


Yves

--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- Perfparse   - http://perfparse.sf.net/                           -

[Perfparse-users] New polls

[Ben C. <bcl...@pe...>]

Dear Users,

New user polls are available on our interactive support site: 
http://wiki.perfparse.org/.

These polls will give feedback to the developers of PerfParse about what 
options and features matter to users, and therefore where future 
programming efforts should be made.

As well as offering a good location for honest discussion on the product 
and any other issues.

Regards,

Ben



-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php