Bug #74405 docs page on optimizer switch seems not to be up to date.
Submitted: 15 Oct 2014 15:19 Modified: 5 Feb 2015 13:27
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:>5.6.8 OS:Windows (probably any)
Assigned to: Paul DuBois CPU Architecture:Any

[15 Oct 2014 15:19] Peter Laursen
Description:
1) This page lists permissbel values for "optimizer_switch" in a table view.  The highest versions listed here are versions  (>= 5.6.7, <= 5.6.8)

http://dev.mysql.com/doc/refman/5.6/en/switchable-optimizations.html also does not.
 
2) On my system "SHOW VARIABLES LIKE 'optimizer_switch'" returns 

index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on .

Some of those listed in docs do not display here ("batched_key_access" for instance). Not sure if this is only a docs issue. They may have been removed.

3) Docs also does not describe what is default for each. Why not? 

How to repeat:
see above

Suggested fix:
update.
[15 Oct 2014 15:41] MySQL Verification Team
On my system 5.6.21 returns same list as documentation, even on your system appears the ("batched_key_access" for instance) check the list you pasted here.Thanks.
[15 Oct 2014 17:51] Peter Laursen
OK .  @Miguel, you are right as regards my 2nd point (but it would be easier if the docs and the statement listed the statements in the same order). My 2nd point invalidated!

However I still think that my 1st and 3rd points are still valid. 

1) Nothing documented for versions above 5.6.8. In docs the world ends with version 5.6.8 :-). Shouldn't it just read >= 5.6.7 ?

2) Defaults are not documented as far as I can see. This can easily be done by adding one more column to the HTML-table.
[15 Oct 2014 17:57] MySQL Verification Team
Thank you for the feedback. Verified 1 and 3.
[5 Feb 2015 13:27] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

Version information is updated here:
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_optimizer_switc...

Defaults for each flag are listed in the table here:
http://dev.mysql.com/doc/refman/5.6/en/switchable-optimizations.html

(ditto for other refman versions)