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

MySQL 8-style optimizer hints: milestone 1

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.
          • Stalled
          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.
          • In Progress

          Activity

            Ascending order - Click to sort in descending order
            oleg.smirnov Oleg Smirnov added a comment -

            ralf.gebhardt, these portion of hints is actually completed and is being reviewed by psergei. I hope we'll pass it for testing at the end of the current sprint.

            oleg.smirnov Oleg Smirnov added a comment - ralf.gebhardt , these portion of hints is actually completed and is being reviewed by psergei . I hope we'll pass it for testing at the end of the current sprint.
            oleg.smirnov Oleg Smirnov added a comment -

            The final version is in the branch 

            bb-opt-hints-1

            .

            oleg.smirnov Oleg Smirnov added a comment - The final version is in the branch bb-opt-hints-1 .
            serg Sergei Golubchik added a comment -

            pushed into bb-11.8-MDEV-35504-opt-hints for buildbot to know the branch so that it could use correct builders

            serg Sergei Golubchik added a comment - pushed into bb-11.8- MDEV-35504 -opt-hints for buildbot to know the branch so that it could use correct builders
            oleg.smirnov Oleg Smirnov added a comment -

            Pushed a new branch bb-11.8-MDEV-35504-opt-hints-v2 including the most recent commits to main.

            oleg.smirnov Oleg Smirnov added a comment - Pushed a new branch bb-11.8- MDEV-35504 -opt-hints-v2 including the most recent commits to main .
            lstartseva Lena Startseva added a comment -

            Testing done, ok to push

            lstartseva Lena Startseva added a comment - Testing done, ok to push

            People

              oleg.smirnov Oleg Smirnov
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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