From: Dan Nelson
Date: January 6 2007 5:04pm
Subject: Re: Indexing issue in slave !!
List-Archive: http://lists.mysql.com/mysql/204263
Message-Id: <20070106170424.GB21598@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jan 06), Himanshu Raina said:
> I am facing a peculiar problem.When i execute a query on slave server
> it doesn't use indexes that have been created and hence read all the
> records present in that table.The same query when execute on Master
> yields proper results.The table structure , table types are same.What
> could be wrong?

If you compare the EXPLAIN SELECT .. outputs for the query on both
servers, what's different?  

-- 
	Dan Nelson
	dnelson@stripped