Page 1 of 1

Re: [Nagios-devel] NDOutils MySQL performance issues

Posted: Mon Sep 08, 2008 6:11 am
by Guest
Hi Thorsten,

On 5 Sep 2008, at 08:20, Thorsten T=FCllmann wrote:

> Thorsten T=FCllmann schrieb:
>> since I had some issues with slow queries on my MySQL-DB, I digged =20=

>> a bit
>> deeper into the NDO database scheme. I would recommend to add some =20=

>> indices:
>
> one more that showed up in the logs:
>
> CREATE INDEX scheduled_time_idx on nagios_timedevents =20
> (scheduled_time);
>
[snipped]

> Maybe Ethan will tell some news in N=FCrnberg next week?

You've preempted one of my topics at the conference! I will reveal =20
some secrets of Opsview (http://opsview.org) which includes some big =20
speed ups in the use of the NDOutils database: =
http://www.netways.de/nagios_konferenz/ ... v/opsview/

Ton

http://www.altinity.com
UK: +44 (0)870 787 9243
US: +1 866 879 9184
Fax: +44 (0)845 280 1725
Skype: tonvoon






This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]