2008/4/11 <[EMAIL PROTECTED]>: > Hi, > > I have 2 MySql server instances. One which is 5.0.27/Debian, another > 5.0.32/Solaris. > > Both instances have the same data in the database. > > And I'm doing a select: > SELECT media.* FROM media,country,content WHERE country.id='Germany' AND > country.detail_tid=content.tid AND content.id=media.content_id; > > This request takes less than a half second on one server, and takes 70 > seconds > on another server. > > The EXPLAIN results are attached to this mail. Its shows that there are > interpreted very differently on each server. > > I checked the database structure, wich is exactly identical on both instance. > > Moreover, one could think that this is the optimizer which does not interpret > the joint request in the right order in the version 5.0.32 compared to > 5.0.27, > but I'm pretty sure that this application had worked in the past (good > performance on 5.0.27). > > Do you know how could I found some clues ?
Shot in the dark, run ANALYZE TABLE on all the relevant tables on the slow server. If you just imported them the indexes may not be well distributed. Please post ddl and relevant SHOW INDEX info. -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
