MySQL Forums
Forum List  »  Optimizer & Parser

Re: running running running
Posted by: Ole John Aske
Date: January 31, 2012 05:00PM

Setting a lower optimizer_search_depth will reduce the number of query plans the optimizer evaluates in order to find the 'best' plan. This will reduce the time used to optimize the query, but comes with the risk that the best execution plan is not found.

However, if you are happy with the query performanance you are experiencing, a lower optimizer_search_depth in the range 4..10 might be a good idea.

What you are experiencing here has been reported as bug#41740 and bug#58225 and has been fixed with an improved optimizer algorithm in MySQL 5.6.3.
This fix will remove the need for fidling with the optimizer_search_depth setting.

I will link your reported bug#64165 with these, and close it as a duplicate.

Edited 1 time(s). Last edit at 01/31/2012 05:00PM by Ole John Aske.

Options: ReplyQuote

Written By
January 30, 2012 03:16AM
January 30, 2012 02:39AM
January 30, 2012 09:13AM
January 31, 2012 05:44AM
January 31, 2012 07:54AM
January 31, 2012 03:10AM
Re: running running running
January 31, 2012 05:00PM

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.