Re: running running running
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.
Subject
Views
Written By
Posted
2247
January 30, 2012 03:16AM
1249
January 30, 2012 02:39AM
1035
January 30, 2012 09:13AM
1020
January 31, 2012 05:44AM
1130
January 31, 2012 07:54AM
1260
January 31, 2012 03:10AM
Re: running running running
1214
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.