List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:January 6 2007 5:04pm
Subject:Re: Indexing issue in slave !!
View as plain text  
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
Thread
Indexing issue in slave !!Himanshu Raina6 Jan
  • Re: Indexing issue in slave !!Dan Nelson6 Jan