ndoutils Query optimisation

[Marc Powell]

On Aug 20, 2008, at 7:08 AM, Thomas Guyot-Sionnest wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 20/08/08 04:56 AM, Alan Cooper wrote:
>> I am having problem scaling up a system we use to gather status data
>> from the NDO db:
>>

>> Does anyone have any suggestions for improving performance of this  
>> query?
>
> I'm not a SQL guru, but here's some thing I'd try... You may get  
> better
> help from SQL/MySQL communities.
>
> * Make sure obj1.name1 is indexed (or is a PK)
> * Make sure every columns in the JOINs are indexed/PKs
> * Try removing the ORDER BY (i.e. sort it in the application running  
> the
> query instead)

I too am not a mysql expert but have some experience with custom ndodb  
queries... Having proper indexes for the query can make all the  
difference in the world. The EXPLAIN command, and the many web pages  
that detail it's use, can be of great assistance in determining which  
indexes should be created for your query and their benefit.

--
Marc

-------------------------------------------------------------------------
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=/
_______________________________________________
Nagios-users mailing list
Nagios-users at 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