RE: [Perfparse-users] DB Size grows very fast since v101.01

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

| perfdata_service_bin | InnoDB | Dynamic    | 7005182 |            104 |=
   731906048 |            NULL |   1695547392 |         0 |        697116=
1 | NULL        | NULL        | NULL       |                | InnoDB free=
: 4096 kB; (`host_name` `service_description`) REFER `nagios/perfdata_ser=
vice`(`host_name` `service_description`); (`host_name` `service_descripti=
on` `metric`) REFER `nagios/perfdata_service_metric`(`host_name` `service=
_description` `metric`) |=20

So the Data lenght of the perfdata_service_bin is already at 730MB and th=
e index size is 1.6GB ... In 3Days!

Here's the output for the raw table:
| perfdata_service_raw | InnoDB | Dynamic    | 3730416 |            135 |=
   506462208 |            NULL |    401457152 |         0 |        361123=
9 | NULL        | NULL        | NULL       |                | InnoDB free=
: 4096 kB; (`host_name` `service_description`) REFER `nagios/perfdata_ser=
vice`(`host_name` `service_description`) |

The serviceperf.log has only 164MB of size and hasn't been deleted since =
Tuesday!

Regards, Philipp

> -----Original Message-----
> From: Ben Clewett [mailto:Be...@cl...]=20
> Sent: Friday, October 22, 2004 11:13 AM
> To: Sand Philipp
> Cc: per...@li...
> Subject: Re: [Perfparse-users] DB Size grows very fast since v101.01
>=20
> Phillipp,
>=20
> Nothing new added, sorry.
>=20
> The innodb table space is not linear.  For historical reasons=20
> it uses large files of a fixed size.  The size is defined in=20
> the my.cfg (I believe).  My guess is that your table space=20
> size in this file is defined as ~3GB.  Or there is some other=20
> similar logical reason.
>=20
> Please check as well your log files.  These can grow faster=20
> than the table space.
>=20
> Regards, Ben.
>=20
>=20
> Sand Philipp wrote:
>=20
> > Hello,
> >=20
> > I created a brand new innodb Database since upgrading to=20
> 101.01. In this db I insert data for ~300 hosts ~2000 metrics.=20
> > This Database has been created this Tuesday (10/19/2004)=20
> and it's already 3GB huge today (10/22/2004). With version=20
> 100 and earlier I had a database with the same amount of=20
> hosts and metrics and had a Database size of about 8GB, but=20
> this had been running for a few months!
> > Had there been some fields modifications in the database?
> >=20
> > Regards,
> > Philipp
> >=20
> > _____________________________
> >=20
> > Philipp Sand
> > OC-CC-TEC-SYS
> >=20
> > SYCOR GmbH
> > Heinrich-von-Stephan-Stra=DFe 1-5
> > D - 37073 G=F6ttingen
> >=20
> > Telefon	+49 (0) 551 / 490 - 0
> > Telefax	+49 (0) 551 / 490 - 232468
> >=20
> > phi...@sy...
> > www.sycor.de
> > ------------------------------------------------
> >=20
> >=20
> >=20
> > ************************************************
> >=20
> > sycor plastics - die neue Branchenl=F6sung f=FCr die Kunststoffindust=
rie
> >=20
> > www.sycor-plastics.de
> >=20
> > ************************************************
> >=20
> >=20
> >=20
> >=20
> > Diese E-Mail ist vertraulich und kann dar=FCber hinaus=20
> pers=F6nliche Informationen beinhalten. Wenn Sie nicht der=20
> bestimmungsgem=E4=DFe Empf=E4nger sind, l=F6schen Sie bitte die=20
> E-Mail und deren Anh=E4nge sofort und benachrichtigen Sie uns=20
> dar=FCber. Die Firma sycor willigt in keine Vertr=E4ge oder=20
> vertragliche Verpflichtungen ein oder =FCbermittelt=20
> rechtsverbindliche Angebote, die in Form von E-Mail versandt=20
> werden, sofern dies nicht ausdr=FCcklich in schriftlicher Form=20
> zwischen den Parteien vereinbart wurde.
> >=20
> > This e-mail is confidential and may contain personal and/or=20
> privileged information. If you are not the intended recipient=20
> please delete this e-mail and all attachments immediately and=20
> inform us. The company sycor does not agree with contracts or=20
> contract obligations sent by e-mail, neither do we transmit=20
> legally binding offers by e-mail, unless this is not=20
> expressly agreed upon between the parties and documented in=20
> written form.
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > This SF.net email is sponsored by: IT Product Guide on=20
> > ITManagersJournal Use IT products in your business? Tell us=20
> what you=20
> > think of them. Give us Your Opinions, Get Free ThinkGeek Gift=20
> > Certificates! Click to find out more=20
> > http://productguide.itmanagersjournal.com/guidepromo.tmpl
> > _______________________________________________
> > Perfparse-users mailing list
> > Per...@li...
> > https://lists.sourceforge.net/lists/listinfo/perfparse-users
> >=20
>=20
>=20

************************************************

sycor plastics - die neue Branchenl=F6sung f=FCr die Kunststoffindustrie

www.sycor-plastics.de

************************************************

Diese E-Mail ist vertraulich und kann dar=FCber hinaus pers=F6nliche Info=
rmationen beinhalten. Wenn Sie nicht der bestimmungsgem=E4=DFe Empf=E4nge=
r sind, l=F6schen Sie bitte die E-Mail und deren Anh=E4nge sofort und ben=
achrichtigen Sie uns dar=FCber. Die Firma sycor willigt in keine Vertr=E4=
ge oder vertragliche Verpflichtungen ein oder =FCbermittelt rechtsverbind=
liche Angebote, die in Form von E-Mail versandt werden, sofern dies nicht=
 ausdr=FCcklich in schriftlicher Form zwischen den Parteien vereinbart wu=
rde.

This e-mail is confidential and may contain personal and/or privileged in=
formation. If you are not the intended recipient please delete this e-mai=
l and all attachments immediately and inform us. The company sycor does n=
ot agree with contracts or contract obligations sent by e-mail, neither d=
o we transmit legally binding offers by e-mail, unless this is not expres=
sly agreed upon between the parties and documented in written form.