Hi,
You can modify that number of days from the setup.php screen.
If it says -log means that its witting a binary log of any changes that can make
it slower, please read the mysql manual on how to disable the binlog.
Whats the Load on your server? do you have MySQL and JFFNMS running on the same
disk?
How fast is the disk? you could run dstat to find out how many traffic is going
to the disk.
And I would recommend you to upgrade to 0.8.2
Javier
Christophoros Zonias wrote:
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] <mailto:[EMAIL PROTECTED]>
CYTA - CYTANET
Fax # : 22486634
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
jffnms-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jffnms-users
