[MDEV-19799] Change optimizer_search_depth default to 0 Created: 2019-06-19 Updated: 2019-07-18 Resolved: 2019-07-18 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Igor Babaev |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||
| Description |
|
It might make sense to change the default value of optimizer_search_depth to 0. https://mariadb.com/kb/en/library/server-system-variables/#optimizer_search_depth If the default value is 0, then users are less likely to complain about long planning times and they'll be less likely to think that the server is hung. |