[Perfparse-users] Problems with slow insert into mysql DB

[Sand P. <Phi...@sy...>]

Hi,

don't know if some can help me out with that in this list...but here's =
the question:

my perfparse mysql DB has grown in size over the last months...the poor =
little mysql DB is about 41GB of size ;)
For inserting the Data in the Database I use the Method, where Nagios =
puts the Data into a serviceperf.log, perfparse gets to this data every =
10 minutes and Nagios is reloaded then.
For an insert of about 200KB it takes about 1.30minutes and it seems as =
it keeps getting slower and slower...

Are there some limits for mysql databases regarding the lines of one =
table or something?? Any "tuning" tips?

Currently I'm using mysql 4.0.21 on fedora core 2 and a Dual 1,4GHz CPU =
Server with 2GB RAM and 2 Ultra 320 SCSI Harddrives...


BTW,
About half a year ago, there was a plan to redesign the perfparse =
database... any news to this? ;)

Thanks in advance!
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
------------------------------------------------
=A0