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.
          • In Review
          relates to

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

          • Major - Major loss of function.
          • Stalled
          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
            psergei Sergei Petrunia created issue -
            psergei Sergei Petrunia made changes -
            Field Original Value New Value
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            Component/s Optimizer [ 10200 ]
            psergei Sergei Petrunia made changes -
            Assignee Sergei Petrunia [ psergey ]
            psergei Sergei Petrunia made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            psergei Sergei Petrunia made changes -
            Assignee Sergei Petrunia [ psergey ] Oleg Smirnov [ JIRAUSER50405 ]
            serg Sergei Golubchik made changes -
            Summary MySQL 8-style optimizer hints: portion 1 MySQL 8-style optimizer hints: milestone 1
            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 made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            oleg.smirnov Oleg Smirnov made changes -
            Assignee Oleg Smirnov [ JIRAUSER50405 ] Elena Stepanova [ elenst ]
            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 .
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Lena Startseva [ JIRAUSER50478 ]
            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
            serg Sergei Golubchik made changes -
            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 .
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Preview_11.8
            oleg.smirnov Oleg Smirnov made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 11.9 [ 29945 ]
            Fix Version/s 11.8 [ 29921 ]
            lstartseva Lena Startseva made changes -

            People

              lstartseva Lena Startseva
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.