NDOutils MySQL performance issues

[Ton Voon]

Hi Thorsten,

On 5 Sep 2008, at 08:20, Thorsten Tüllmann wrote:

> Thorsten Tüllmann schrieb:
>> since I had some issues with slow queries on my MySQL-DB, I digged  
>> a bit
>> deeper into the NDO database scheme. I would recommend to add some  
>> indices:
>
> one more that showed up in the logs:
>
> CREATE INDEX scheduled_time_idx on nagios_timedevents  
> (scheduled_time);
>
[snipped]

> Maybe Ethan will tell some news in Nürnberg next week?

You've preempted one of my topics at the conference! I will reveal  
some secrets of Opsview (http://opsview.org) which includes some big  
speed ups in the use of the NDOutils database: http://www.netways.de/nagios_konferenz/y2008/programm/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 SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/