Nagios with NDOUtils is not working any more.

[seb]

> Just adding some few indexes to the database would help the load
> enormously. I remember Ton Voon giving a speech at Nagios Konferenz
> in germany last year, stating that analyzing the queries and then
> creating the appropriate indexes boosted performance by as close
> to 300000% (querytimes dropped from 146secs down to 0.2).
>
> This is off the top of my head though, so take the numbers with a
> grain of salt.

I've asked mysql to log queries not using indexes, and ended adding a
couple of indexes on a table or two. One of the SELECTs used by
PNP was not using any index at all. I was tempted to add an index
on all "datetime" fields but it would be overkill :)
Now mysql outputs no warning (and no slow queries) but my
test instance is too smalll...  Time for me to monitor everything
twice and see what happens :)

-- 
seb

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
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