List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 14 1999 5:41pm
Subject:Re: very slow 3.23.5-alpha
View as plain text  
>>>>> "Arne" == Arne Mueller <a.mueller@stripped> writes:

select 
	Query.Name 
from 	Target, Query, Hit, Region, Member, scop37.Entry, scop37.Domain, 
	scop37.Protein, scop37.Family, scop37.Superfamily 
where 
	Query.Shortorg = 'MG'  and 
	Query.Id = Region.QueryId and  
	Member.Id = Region.AssignmentId and 
	Region.PrevId is NULL and   
	Member.HitId = Hit.Id and    
	Hit.TargetId =  Target.Id and  
	scop37.Entry.Name = Target.Name and 
	scop37.Domain.EntryId = scop37.Entry.Name and 
	scop37.Domain.ProteinId = scop37.Protein.Id and  
	scop37.Family.Id = scop37.Protein.FamilyId and 		
	scop37.Family.SuperfamilyId = 111;

The above select gives the following result with mysql version 3.23.5:

+-------+
| Name  |
+-------+
| MG455 |
+-------+
1 row in set (16 min 52.46 sec)

and with 3.22.25:

+-------+
| Name  |
+-------+
| MG455 |
+-------+
1 row in set (11.10 sec)

Hi!

Any change you can post the result of EXPLAIN SELECT ... of the query
on both machines ?

You could also try to do:

myisamchk -a */*.MYI
isamchk -a */*.ISM
mysqladmin flush-tables

and check if this has any affect on the EXPLAIN results.

Regards,
Monty
Thread
very slow 3.23.5-alphaArne Mueller26 Oct
  • Re: very slow 3.23.5-alphaTonu Samuel26 Oct
  • Re: very slow 3.23.5-alphaArne Mueller26 Oct
    • Re: very slow 3.23.5-alphaMichael Widenius14 Nov
  • Re: very slow 3.23.5-alphaTonu Samuel26 Oct
  • Re: very slow 3.23.5-alphaTonu Samuel26 Oct
  • Re: very slow 3.23.5-alphaArne Mueller26 Oct
  • Re: very slow 3.23.5-alphaArne Mueller26 Oct