Nagios + PostgreSQL = high cpu load?

[Ben]

You can also find my code at 
http://www.sourceforge.net/projects/nagios-db/

It does require upgrading to Nagios 2, a process that should be 
painless and leave you with a better system than you started with 
anyway.

On Dec 27, 2004, at 8:23 AM, Andreas Ericsson wrote:

> Mikolaj Rydzewski wrote:
>> Hello all!
>> I'm using Nagios 1.2, installed from ports on FreeBSD 5.2.1. I've 
>> compiled PostgreSQL support in. And now I can see unusual high cpu 
>> load - mostly due to postmaster activity. Take a look at mrtg graph 
>> at http://ceti.pl/~miki/test/k2_cpu-week.png - I've installed nagios 
>> last week, and finally polished its confguration on friday.
>> I'm not a newbie PostgreSQL user, IMHO it's tuned fine (fsync set to 
>> off, big cache). Our website is postgresql driven (it's PostgreSQL 
>> 7.4.1 there). But nagios seems to take our database to its knees :-(
>> I've got 36 service checkers on 7 hosts now. Our server is 2GHz AMD, 
>> 512MG RAM - so it's rather powerful machine.
>> Maybe PostgreSQL is not the best choice to use with Nagios? Does 
>> mysql work better?
>
> Probably not. The problem with Nagios and DB support is the way it is 
> implemented. Each status-change causes a flush and recreation of a 
> very flat table. This causes the db server to eat an extraordinary 
> amount of CPU each time the status is updated.
>
> There's supposed to be pretty nice database support for Nagios 2 with 
> a NEB-module posted to nagios-devel a couple of weeks ago.
>
> -- 
> Andreas Ericsson                   andreas.ericsson at op5.se
> OP5 AB                             www.op5.se
> Lead Developer
>
>
> -------------------------------------------------------
> 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://productguide.itmanagersjournal.com/
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when 
> reporting any issue. ::: Messages without supporting info will risk 
> being sent to /dev/null



-------------------------------------------------------
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://productguide.itmanagersjournal.com/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null