or give some pointers on where one would start to verify this? I have no idea where to
even start to see if I am missing any indexes.
Thanks Chris
Craig Small wrote:
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
------------------------------------------------------- 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
