LP:891052 - semijoin_with_cache , outer_join_with_cache, mrr, mrr_sort_keys, mrr_cost_based are missing from some representations of optimizer_switch

The outer_join_with_cache and semijoin_with_cache options are missing from @@optimizer_switch . I thought that this was because those options were deprecated and removed on purpose, but now I see that they are still valid if specified manually.

To repeat:

mysqld --verbose --help | grep optimizer_switch | grep join_with_cache

Maybe there are other such options. Ideally, there should be one unified list of allowable optimizer_switches.