MySQL Forums
Forum List  »  InnoDB

Re: can mysql use 2 different execution plans for the same query ?
Posted by: Cyril SCETBON
Date: May 13, 2011 09:09AM

actually, I was talking about having 2 different execution plans when passing the same arguments to the procedure (ie it uses the same query in the both calls). However, I'm convinced it's due to the statistics recalculation. I've found that we connect with mysql commandline and auto-rehash option, which in fact forces recalculation when innodb_stats_on_metadata is enable. I've disabled it, played with innodb_stats_sample_pages and analyze my tables and it seems to be better ...
I'll let you know if something weird appears again.

What do you think about my conclusions ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: can mysql use 2 different execution plans for the same query ?
944
May 13, 2011 09:09AM


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.