It would be nice to do a GUI to setup events erases. Use of jffnms for central loggin can fill the events-syslog-snmp tables quick (I have a database with more than 5 000 000 events). The GUI would be nice if we can select: events-types, hosts, erase periodicity, text match and perhaps an extra info field to customize the mysql queries.
_________________________________ David LIMA Professional Services www.scc.com -----Message d'origine----- De�: Javier Szyszlican [mailto:[EMAIL PROTECTED] Envoy�: lundi 29 novembre 2004 0:47 Cc�: [EMAIL PROTECTED] Objet�: Re: [jffnms-users] performance graphs skipping time Craig, What file are you talking about? cleanup_raw_tables.php deletes all the events in the DB that have X days old. Do you have another script that cleans up unknown events? If thats the case, shouldn't that be integrated in cleanup_raw_tables ? Anyway, the problem may be related to the interface in question flapping a lot, and the consolidate script can't keep up with it, so the poller may think the interface is down at the moment, and not poll it. Javier Craig Small wrote: > On Tue, Nov 16, 2004 at 10:43:09PM -0600, Chris Norman wrote: > >>My graphs are skipping. It appears to happen about every 30 minutes or so. >> >>Has anyone else experienced this? > > > Yes, quite a few times. > It has been almost always due to the speed of the database. The speed of > the database is due to the size of the tables, most importantly the > events table. > > I've got a graph that has on the left only "fingers" of traffic and > on the right a solid block of traffic. The only difference is around > the middle of the graph I nuked a whole bunch of junk out of the events > table. > > > delete from events where type=1; > delete from events where type=45; > > If you are having NT syslog stuff to your JFFNMS system and you are > not trimming your tables you will have problems. I had 650,000 events > of type 45. > > I think cleanup_unknown_events.php needs to be changed so that type > 45 gets deleted too. I've changed the relevant line to: > > $query = "delete from events where date <= '$dtdelete' AND (type = 1 OR type > = 45)"; > > - Craig -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED] I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate ------------------------------------------------------- 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/ _______________________________________________ jffnms-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jffnms-users - ------------------------------------------------------------------------------------------ Ce message contient des informations dont le contenu est susceptible d'�tre confidentiel. Il est destin� au(x) destinataire(s) indiqu�(s) exclusivement. A moins que vous ne fassiez partie de la liste des destinataires, ou que vous soyez habilit� � recevoir le mail � leur place, il vous est interdit de le copier, de l'utiliser ou de d�voiler son contenu � un tiers. Si vous avez re�u cet email par erreur, merci de prendre contact avec l'�metteur. Les opinions exprim�es dans cet e-mail sont celles de l'�metteur et ne refl�tent pas n�cessairement celles de l'entreprise. Ce e-mail peut contenir des pi�ces jointes dont certaines pourraient contenir des virus qui pourraient endommager votre syst�me informatique. La compagnie a pris toutes dispositions afin de minimiser ce risque et d�cline toute responsabilit� pour toute perte ou dommage r�sultant directement ou indirectement de l'utilisation de cet email ou de son contenu. Il vous appartient d'effectuer vos propres contr�les anti-virus avant d'ouvrir la ou les pi�ces jointes. ------------------------------------------------------------------------------------------ ------------------------------------------------------- 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/ _______________________________________________ jffnms-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jffnms-users
