MySQL Forums
Forum List  »  Optimizer & Parser

Re: Identical servers different plan for the same query
Posted by: Eric Coll
Date: April 10, 2012 03:28PM

I think that the general solution to this type of problem is to increase the number of page sample in the statistics.

This settings worked for me:
innodb_stats_sample_pages = 32
innodb_stats_on_metadata = OFF

I have several problems across the database where the statistics and query plans were incorrect, and this setting has solved them all.

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.