Hello, If you are running a large JFFNMS system and are wondering why things are not going as great as they should, you might like to have a read.
We've got just under 100 hosts and just under 2500 interfaces. They're running on two (one for JFFNMS, one for the DB) P4 2.8 GHz hosts with 1G of memory each. The load on these servers is pretty low, if we use the new poller the load average rarely goes over 1. Nice fast SATA disks too. So everything should of been going great. Nice fast responses and zippy website pages, all is well. Well, it was very good for most of the time, but every now and then, say 1/4 web refreshes of the events or map, the response sucked. I mean it was seriously bad; like 20 seconds for the website to return a screen. After some debugging, I found not only was the website slow, but the pollers were not working right, my graphs were "gappy", all was very bad. More debugging found that the events consolidator was the problem, specifically the big SQL query at the start (engine/consolidate/events.php) It blocked all queries, even ones on the mysql command line. The loads were very low on both servers. The problem was due to a missing database index (thanks to Javier, he nailed it on the first reply - the trick was then working out which index was missing). The difference was amazing, the query went from 20+ seconds to around 1 or so. Graphs are no longer gappy and the website pages are very nice and quick. My databases are pretty old, I think they are 0.7.8 or around that. If you get bad response from JFFNMS you might like to check that your indexes are there. - Craig -- Craig Small GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5 Eye-Net Consulting http://www.enc.com.au/ MIEE Debian developer csmall at : enc.com.au ieee.org debian.org ------------------------------------------------------- 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://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
