Indexing issue in slave !!

2007-01-06 Thread Himanshu Raina 
Hi,

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?

regards
Himanshu Raina

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Indexing issue in slave !!

2007-01-06 Thread Dan Nelson 
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
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]