Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19799

Change optimizer_search_depth default to 0

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • N/A
    • Optimizer
    • None

    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.

      Attachments

        Activity

          People

            igor Igor Babaev
            GeoffMontee Geoff Montee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.