MySQL Forums
Forum List  »  Optimizer & Parser

Re: Identical servers different plan for the same query
Posted by: irek kordirko
Date: April 07, 2012 02:54PM

Please run SHOW TABLE STATUS and SHOW INDEX commands for all tables used by the query on both serwers and post output of these commands.
Have you tried to run ANALYZE TABLE on the slave ?
Try to analyze tables on both servers to refresh statistics and then compare plans again.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.