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

MySQL 8-style optimizer hints: milestone 1

    XMLWordPrintable

Details

    Description

      This includes the subset of hints provided in the first patch.

      • QB_NAME
      • NO_RANGE_OPTIMIZATION
      • NO_ICP
      • MRR, NO_MRR
      • BKA, NO_BKA
      • BNL, NO_BNL

      See MDEV-35483 for detailed documentation.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34860 Implement MAX_EXECUTION_TIME hint

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36133 Hint BNL() doesn't work when join_cache_level>= 5 or join_cache_hashed=off

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36169 If strategies in hint SEMIJOIN are named but inapplicable for the statement, DUPSWEEDOUT shoud be used, but is does not work for engines Aria and InnoDB

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-35483 Docs for optimizer hints

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36486 Optimizer hints are resolved against the INSERT part of INSERT..SELECT

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          split from

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-33281 Implement optimizer hints like in MySQL 8

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Activity

            People

              oleg.smirnov Oleg Smirnov
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.