Re: [Nagios-devel] NDOutils MySQL performance issues
Posted: Mon Sep 08, 2008 6:11 am
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]
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]