ndoutils Query optimisation

[Alan Cooper]

Mikael Fridh wrote:
> On Wed, Aug 20, 2008 at 8:46 PM, Alan Cooper <ajcooper80 at googlemail.com> wrote:
>   
>> 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.
>>     
>
> Show the EXPLAIN output as well as SHOW CREATE TABLE for all tables in
> your query.
>
>   

Hi Mikael,

Please find the details requested attached.

Thanks again for your help.

Regards,
Alan
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: explain.txt
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080825/9c561246/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: schema.sql
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080825/9c561246/attachment.ksh>
-------------- next part --------------
-------------------------------------------------------------------------
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=/
-------------- next part --------------
_______________________________________________
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