|
Hi guys, I am using MySQL and the performance of JFFNMS it 's
actually very slow. It takes long time to login, long time to watch the
performance graphs, long long time to get the reports. I had a lot of slow queries especially on the events
and alarm tables where it grew too much (had a lot of columns) I manually run the script /usr/internet/php/bin/php -c /etc/ /data/opt/jffnms/engine/cleanup_raw_tables.php
And I received the following: 10:07:27 Cleaning up raw messages older than
2005-09-07 00:00:00 (7 days)... 10:07:27 Cleanup of traps/traps_varbinds tables
finished... (1, 0) 10:07:27 Cleanup of acct table finished... (1) 10:07:27 Cleanup of syslog table finished... (1) 10:07:27 Cleaning up Events/Alarms older than
2005-07-16 00:00:00 (60 days)... 10:07:27 Cleanup of alarms table finished... (1) 10:07:27 Cleanup of events table finished... (1) 10:07:27 Cleaning up Host Configs older than
2005-08-15 00:00:00 (30 days)... 10:07:27 Cleanup of hosts_config table finished... (1) 10:07:27 Repairing events table...10:07:27 done,
OK/OK/1 10:07:27 Repairing alarms table...10:09:13 done,
OK/OK/1 10:09:13 Repairing traps table...10:09:13 done,
OK/OK/1 10:09:13 Repairing syslog table...10:09:13 done,
OK/OK/1 10:09:13 Repairing acct table...10:09:13 done, OK/OK/1 10:09:13 Repairing hosts_config table...10:09:13 done,
OK/OK/1 Can anyone help me on modifying the script so that I
can clean the Events/Alarms earlier than 60 days. Lets say 5 days. Thanks P.S. I am using Mysql version : 4.0.16-standard-log
Jffnms 0.81 Christophoros Zonias e-mail address: [EMAIL PROTECTED] CYTA - CYTANET Fax # : 22486634 |
- [jffnms-users] MySQL slow queries causing slow perfor... Christophoros Zonias
- Re: [jffnms-users] MySQL slow queries causing sl... Javier Szyszlican
