> 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@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