Re: [Nagios-db-devel] performance query

[Ben <be...@si...>]

Well, I can only speak to the postgres module, but here's what I found:

Nagios 2 works a lot better than Nagios 1. I can't recall how much 
better, but I do recall it still wasn't scalable enough for our 
purposes. So, enter Nagios-DB. The big point of nagios-db for me was to 
precompute as much data as was possible with the use of materialized 
views. That way, when the interface wanted to see some metrics, 
gathering those metrics is usually little more than pulling numbers 
straights from a static table. Nice and fast. So from an interface 
point of view, nagios-db works wonderfully.

There are two potential gotchas. First, the postgres nagios-db uses 
snapshot materialized views, meaning they refresh periodically, not in 
realtime. I have pretty beefy hardware, so I can set mine to refresh 
every minute, but for a tool that's supposed to tell you when things 
are down, I think updating every minute is pretty overkill. Once every 
5 minutes would probably be just fine.

The other potential gotcha is that nagios has to write the value of 
each check into the db to complete a check, and if the db is slammed, 
this will take an increasing amount of time. This was causing me very 
bad latency problems (thousands of seconds) until recently, when I 
implemented some thread pool action in the NEB and now my latency times 
tend to hover around 15 seconds.

That thread pool-enabled version of nagios still lives in CVS only; 
once I write some documentation, I'll be making another release.

On Apr 28, 2005, at 1:54 AM, Dan Hopkins wrote:

> Hi Ben and co,
> How are you finding performance with the NEB db modules? I ask because 
> I'm
> assuming it's the closest thing to Nagios1.2+db support with aggregated
> updates turned off (?), and having done this recently (on a 3gig xeon 
> with
> 2gig ram running around 3700 services across 3500 hosts) the load 
> increased
> from a palatable 1-2 to a more hefty 4-5. Still perfectly usable, but 
> it did
> make me wonder how the event based neb modules perform - I'll be 
> upgrading
> to 2.x+NEB as soon as the 2 branch is officially stable.
>
> Has anyone done scalability testing they could share?
>
> Thanks
> -- 
> Dan Hopkins
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Tell us your software development plans!
> Take this survey and enter to win a one-year sub to SourceForge.net
> Plus IDC's 2005 look-ahead and a copy of this survey
> Click here to start!  http://www.idcswdc.com/cgi-bin/survey?id=105hix
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel