ndoutils Query optimisation

[Alan Cooper]

Thomas Guyot-Sionnest wrote:
>
> 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)
>
> You can also try importing the tables to a different engine (i.e. InnoDB
> vs MyISAM) in a new db or with different names, and benchmark it on them.
> --
>   
Thanks for the replies,

Unfortunately, all the tables are already indexed so I'm back to the 
underlying problem is that there are so many joins on big tables so 
MySQL has to copy to temp tables each time - I'd really like to 
eliminate the need for this if possible.

Any help gratefully received

-------------------------------------------------------------------------
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