On 28.09.2013 01:04, James Nedila wrote: > On 27 September 2013 10:55, Michael Friedrich > <michael.friedr...@gmail.com <mailto:michael.friedr...@gmail.com>> wrote: > > On 27.09.2013 19 <tel:27.09.2013%2019>:40, James Nedila wrote: > > On 27 September 2013 00:56, Michael Friedrich > > <michael.friedr...@gmail.com > <mailto:michael.friedr...@gmail.com> > <mailto:michael.friedr...@gmail.com > <mailto:michael.friedr...@gmail.com>>> wrote: > > > > > And is there a list somewhere of exactly what DB tables fall > > under each > > > Data Processing Option flag? > > > > see https://dev.icinga.org/issues/4479 && (test git 'next' > || wait > > for 1.10) > > > > > > This is perfect, and exactly what I was looking for. > > I'll update to the latest release and patch this in. > > lemme know how it goes - my tests worked fine though. > > > As a quick update, this patch definitely helped. > We use custom variables heavily, and updates to the > customvariablestatus table were taking up approx 40% of our DB queries. > > After applying the patch to 1.9.3, our DB load dropped considerably.
good to know, so I'll add that to the best-of-seven for the release blog post then (and as argument against people claiming that 1.x development is dead cause 2.x is coming). > > Thanks a bunch for your help! np - thanks for testing, much appreciated. > > > btw - in the future, please create a new mail thread (click on new > mail, > instead of reply changing the topic). right now your thread is linked > below "[icinga-devel] Icinga redesign". > > > That's strange, as I was just replying to this email... I didn't > consciously change the topic. yeah sorry. seems my icedove at work thinks different to the one at home. kind regards, michael -- DI (FH) Michael Friedrich mail: michael.friedr...@gmail.com twitter: https://twitter.com/dnsmichi jabber: dnsmi...@jabber.ccc.de irc: irc.freenode.net/icinga dnsmichi icinga open source monitoring position: lead core developer url: https://www.icinga.org ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users
