Re: [Perfparse-users] (no subject)

[Yves M. <yme...@li...>]

Back from holidays, but many things to do like always after coming back :=
)
So I answer quick and short.
You talk about perfparse-db-purge, so you have a perfparse version higher=
 than 0.99.03.
I don't remember any bug in that tool after 0.99.03. But please tell us w=
hat version you
are using.

> Hi,
>
> I just tried out the perfparse_db_purge, and I don't know what I'm doin=
g wrong, but I
> won't work properly...but without giving error messages...
> I simply start it from the command-line e.g. with #./perfparse-db-purge=
 -n 1
> The the program seems to run and after a while it returns, that it has =
deleted some
> million lines. Looks fine i think.
> But when I commect to the Database, and do some selects on the perfdata=
_host, or on the
> perfdata_service_raw, I got a lot of Data which is older than this 1 da=
y.

There is something strange.
In my version, perfparse-db-purge does not recognize -n option. So no old=
 data was
removed. Use --del-old 1 instead of -n 1 if you want to remove old lines =
with 0.99.08.

Why did it take so much time ? Because there is a feature that is already=
 implemented in
perfparse-db-purge, but not yet in the CGI. There is a record "is_deleted=
" in some
tables. They are set as 0. If you set it at 1, it will be purged when run=
ning
perfparse-db-purge (and all related data, like binary data and raw data i=
f you remove a
host).
This takes some time.

> Which Data is deleted by the perfparse-db-purge tool?

1/ some data when there is is_deleted set to 1
2/ old data, older than what you specify to --del-old.

> BTW, does perfdata needs the data in the perfdata_service_raw table, or=
 can it be
> deleted after perfparse got its bin-data?

Raw data contain the return of the plugin (the message, the state...)
Bin data contain the perf data, after the | character in the plugin messa=
ge

They are independant. Remove what you like.
Of course, do it at your own risks, we are not responsible for... :)

> Would be great if you guys could post somethng like which table got whi=
ch functions,
> thanks!

Better if there is some document somewhere.

Yves

>
> Regards,
> Philipp
>
>
> _____________________________
>
> Philipp Sand
> OC-CC-TEC-SYS
>
> SYCOR GmbH
> Heinrich-von-Stephan-Stra=DFe 1-5
> D - 37073 G=F6ttingen
>
> Telefon	+49 (0) 551 / 490 - 0
> Telefax	+49 (0) 551 / 490 - 232468
>
> phi...@sy...
> www.sycor.de
> ------------------------------------------------
>
>
>
> ************************************************
>
> sycor plastics - die neue Branchenl=F6sung f=FCr die Kunststoffindustri=
e
>
> www.sycor-plastics.de
>
> ************************************************
>
>
>
>
> Diese E-Mail ist vertraulich und kann dar=FCber hinaus pers=F6nliche In=
formationen
> beinhalten. Wenn Sie nicht der bestimmungsgem=E4=DFe Empf=E4nger sind, =
l=F6schen Sie bitte die
> E-Mail und deren Anh=E4nge sofort und benachrichtigen Sie uns dar=FCber=
. Die Firma sycor
> willigt in keine Vertr=E4ge oder vertragliche Verpflichtungen ein oder =
=FCbermittelt
> rechtsverbindliche Angebote, die in Form von E-Mail versandt werden, so=
fern dies nicht
> ausdr=FCcklich in schriftlicher Form zwischen den Parteien vereinbart w=
urde.
>
> This e-mail is confidential and may contain personal and/or privileged =
information. If
> you are not the intended recipient please delete this e-mail and all at=
tachments
> immediately and inform us. The company sycor does not agree with contra=
cts or contract
> obligations sent by e-mail, neither do we transmit legally binding offe=
rs by e-mail,
> unless this is not expressly agreed upon between the parties and docume=
nted in written
> form.
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> 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/                 -
- GTKtalog    - http://www.nongnu.org/gtktalog/                    -