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

Testing of optimizer hints

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Our implementation of optimizer hints is intended to bring compatibility with the corresponding functionality of MySQL, which is described here.

      Currently we have implemented a partial subset of the hints:

      • hints for join buffering: BNL(), NO_BNL(), BKA(), NO_BKA();
      • NO_ICP() hint for disabling index condition pushdown;
      • MRR(), MO_MRR() hint for multi-range reads control;
      • NO_RANGE_OPTIMIZATION() for disabling range optimization;
      • QB_NAME() for assigning names for query blocks;
      • SEMIJOIN() and NO_SEMIJOIN() for semijoin strategy control;
      • SUBQUERY() for control of subquery execution strategy.

      Examples of applying hints to SQL statements can be found at 

      mysql-test/main/opt_hints.test; mysql-test/main/opt_hint_timeout.test; mysql-test/main/opt_hints_subquery.test

      Attachments

        Issue Links

          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 created issue -
            oleg.smirnov Oleg Smirnov made changes -
            Field Original Value New Value
            oleg.smirnov Oleg Smirnov made changes -
            Description Our implementation of optimizer hints is intended to bring compatibility with the corresponding functionality of MySQL, which is [described here|https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html].

            Currently we have implemented a partial subset of the hints:

            * hints for join buffering: BNL(), NO_BNL(), BKA(), NO_BKA();
            * NO_ICP() hint for disabling index condition pushdown;
            * MRR(), MO_MRR() hint for multi-range reads control;
            * NO_RANGE_OPTIMIZATION() for disabling range optimization;
            * QB_NAME() for assigning names for query blocks.

            Examples of applying hints to SQL statements can be found at {code}mysql-test/main/opt_hints.test{code}             		Our implementation of optimizer hints is intended to bring compatibility with the corresponding functionality of MySQL, which is [described here|https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html].

            Currently we have implemented a partial subset of the hints:

            * hints for join buffering: BNL(), NO_BNL(), BKA(), NO_BKA();
            * NO_ICP() hint for disabling index condition pushdown;
            * MRR(), MO_MRR() hint for multi-range reads control;
            * NO_RANGE_OPTIMIZATION() for disabling range optimization;
            * QB_NAME() for assigning names for query blocks.

            Examples of applying hints to SQL statements can be found at {code}mysql-test/main/opt_hints.test{code}
            oleg.smirnov Oleg Smirnov made changes -
            Description Our implementation of optimizer hints is intended to bring compatibility with the corresponding functionality of MySQL, which is [described here|https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html].

            Currently we have implemented a partial subset of the hints:

            * hints for join buffering: BNL(), NO_BNL(), BKA(), NO_BKA();
            * NO_ICP() hint for disabling index condition pushdown;
            * MRR(), MO_MRR() hint for multi-range reads control;
            * NO_RANGE_OPTIMIZATION() for disabling range optimization;
            * QB_NAME() for assigning names for query blocks.

            Examples of applying hints to SQL statements can be found at {code}mysql-test/main/opt_hints.test{code}             		Our implementation of optimizer hints is intended to bring compatibility with the corresponding functionality of MySQL, which is [described here|https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html].

            Currently we have implemented a partial subset of the hints:

            * hints for join buffering: BNL(), NO_BNL(), BKA(), NO_BKA();
            * NO_ICP() hint for disabling index condition pushdown;
            * MRR(), MO_MRR() hint for multi-range reads control;
            * NO_RANGE_OPTIMIZATION() for disabling range optimization;
            * QB_NAME() for assigning names for query blocks;
            * SEMIJOIN() and NO_SEMIJOIN() for semijoin strategy control;
            * SUBQUERY() for control of subquery execution strategy.

            Examples of applying hints to SQL statements can be found at {code}mysql-test/main/opt_hints.test{code}, {code}mysql-test/main/opt_hint_timeout.test{code}, {code}mysql-test/main/opt_hints_subquery.test{code}
            oleg.smirnov Oleg Smirnov made changes -
            Description Our implementation of optimizer hints is intended to bring compatibility with the corresponding functionality of MySQL, which is [described here|https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html].

            Currently we have implemented a partial subset of the hints:

            * hints for join buffering: BNL(), NO_BNL(), BKA(), NO_BKA();
            * NO_ICP() hint for disabling index condition pushdown;
            * MRR(), MO_MRR() hint for multi-range reads control;
            * NO_RANGE_OPTIMIZATION() for disabling range optimization;
            * QB_NAME() for assigning names for query blocks;
            * SEMIJOIN() and NO_SEMIJOIN() for semijoin strategy control;
            * SUBQUERY() for control of subquery execution strategy.

            Examples of applying hints to SQL statements can be found at {code}mysql-test/main/opt_hints.test{code}, {code}mysql-test/main/opt_hint_timeout.test{code}, {code}mysql-test/main/opt_hints_subquery.test{code}             		Our implementation of optimizer hints is intended to bring compatibility with the corresponding functionality of MySQL, which is [described here|https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html].

            Currently we have implemented a partial subset of the hints:

            * hints for join buffering: BNL(), NO_BNL(), BKA(), NO_BKA();
            * NO_ICP() hint for disabling index condition pushdown;
            * MRR(), MO_MRR() hint for multi-range reads control;
            * NO_RANGE_OPTIMIZATION() for disabling range optimization;
            * QB_NAME() for assigning names for query blocks;
            * SEMIJOIN() and NO_SEMIJOIN() for semijoin strategy control;
            * SUBQUERY() for control of subquery execution strategy.

            Examples of applying hints to SQL statements can be found at {code}mysql-test/main/opt_hints.test, mysql-test/main/opt_hint_timeout.test, mysql-test/main/opt_hints_subquery.test{code}
            oleg.smirnov Oleg Smirnov made changes -
            Description Our implementation of optimizer hints is intended to bring compatibility with the corresponding functionality of MySQL, which is [described here|https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html].

            Currently we have implemented a partial subset of the hints:

            * hints for join buffering: BNL(), NO_BNL(), BKA(), NO_BKA();
            * NO_ICP() hint for disabling index condition pushdown;
            * MRR(), MO_MRR() hint for multi-range reads control;
            * NO_RANGE_OPTIMIZATION() for disabling range optimization;
            * QB_NAME() for assigning names for query blocks;
            * SEMIJOIN() and NO_SEMIJOIN() for semijoin strategy control;
            * SUBQUERY() for control of subquery execution strategy.

            Examples of applying hints to SQL statements can be found at {code}mysql-test/main/opt_hints.test, mysql-test/main/opt_hint_timeout.test, mysql-test/main/opt_hints_subquery.test{code}             		Our implementation of optimizer hints is intended to bring compatibility with the corresponding functionality of MySQL, which is [described here|https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html].

            Currently we have implemented a partial subset of the hints:

            * hints for join buffering: BNL(), NO_BNL(), BKA(), NO_BKA();
            * NO_ICP() hint for disabling index condition pushdown;
            * MRR(), MO_MRR() hint for multi-range reads control;
            * NO_RANGE_OPTIMIZATION() for disabling range optimization;
            * QB_NAME() for assigning names for query blocks;
            * SEMIJOIN() and NO_SEMIJOIN() for semijoin strategy control;
            * SUBQUERY() for control of subquery execution strategy.

            Examples of applying hints to SQL statements can be found at {code}mysql-test/main/opt_hints.test; mysql-test/main/opt_hint_timeout.test; mysql-test/main/opt_hints_subquery.test{code}
            oleg.smirnov Oleg Smirnov made changes -
            Assignee Oleg Smirnov [ JIRAUSER50405 ] Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Lena Startseva [ JIRAUSER50478 ]

            People

              lstartseva Lena Startseva
              oleg.smirnov Oleg Smirnov
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.