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

Range cost calculations does not take into acount join_buffer

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 11.0(EOL)
    • 11.0.3, 11.1.2
    • Optimizer
    • None

    Description

      Range cost cost calculations does not take into account join_buffer.

      When 11.0 optimizer was coded, the assumption was that RANGE queries will not use the join buffer (and join buffer flag was not set for these).
      The optimizer would however decide later to use join buffer, which means that the cost
      calculations for ranges did not match reality, which could mean that the optimizer could
      use a worse plan.

      The task is to fix that range + join_buffer cost is calculated correctly.

      This is a bit complex to do as the 'range total cost' that best_access_plan() is not specific
      enough to allow correct calculation of range + join_buffer.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              monty Michael Widenius
              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.