From: Ben C. <BC...@pa...> - 2005-07-14 20:56:12
|
Same issue here, after about a month monitoring about 1100 services I = was at 4+GB and then my Db got corrupted (hardware issue). At the time I = think I had about 10 million rows in the bin/data tables. I've got a bigger, faster server now, I'm not sure what to do beyond = setting the delete retention and using the 'is_deleted' column in some of the tables. You can set the bin/data deletion policy, and use perfparse-db-purge, maybe that will help. =20 Over all it stinks if you have to delete valuable data. Ben -----Original Message----- From: Sand Philipp [mailto:Phi...@sy...] Sent: Thursday, July 14, 2005 7:10 AM To: per...@li... Subject: [Perfparse-users] Problems with slow insert into mysql DB 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 ------------------------------------------------------- This SF.Net email is sponsored by the 'Do More With Dual!' webinar = happening July 14 at 8am PDT/11am EDT. We invite you to explore the latest in = dual core and dual graphics technology at this free one hour event hosted by = HP,=20 AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar _______________________________________________ Perfparse-users mailing list Per...@li... https://lists.sourceforge.net/lists/listinfo/perfparse-users ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email=20 ______________________________________________________________________ |