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

New-style hints: [NO_]DERIVED_CONDITION_PUSHDOWN, [NO_]MERGE

Details

    • Task
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.1
    • Optimizer
    • None

    Description

      Implement table-level hints:

      MERGE, NO_MERGE 
      DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN

      in the same way they're done in MySQL 8. See MySQL docs at:
      https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
      https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html#optimizer-hints-table-level

      The logic for enabling the hints is expected to be very basic - hook at the same place where the check for optimizer_switch is, override the optimizer_switch setting.

      The code to base on is MDEV-35504, look at other similar level hints and copy the approach.

      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
            psergei Sergei Petrunia created issue -
            psergei Sergei Petrunia made changes -
            Field Original Value New Value
            Description This is for compatibility with MySQL 8 hints. See MySQL docs at:
            https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            Description This is for compatibility with MySQL 8 hints. See MySQL docs at:
            https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html             		This is for compatibility with MySQL 8 hints. See MySQL docs at:
            https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html

            DERIVED_CONDITION_PUSHDOWN,
            psergei Sergei Petrunia made changes -
            Description This is for compatibility with MySQL 8 hints. See MySQL docs at:
            https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html

            DERIVED_CONDITION_PUSHDOWN,             		Implement table-level hints:
            {code}
            DERIVED_CONDITION_PUSHDOWN,
            NO_DERIVED_CONDITION_PUSHDOWN
            {code}

            in the same way they're done in MySQL 8. See MySQL docs at:
            https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
            https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html#optimizer-hints-table-level

            psergei Sergei Petrunia made changes -
            Summary New-style hint: [NO_]DERIVED_CONDITION_PUSHDOWN New-style hint: [NO_]DERIVED_CONDITION_PUSHDOWN, [NO_]MERGE
            psergei Sergei Petrunia made changes -
            Description Implement table-level hints:
            {code}
            DERIVED_CONDITION_PUSHDOWN,
            NO_DERIVED_CONDITION_PUSHDOWN
            {code}

            in the same way they're done in MySQL 8. See MySQL docs at:
            https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
            https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html#optimizer-hints-table-level

            		Implement table-level hints:
            {code}
            MERGE, NO_MERGE
            DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN
            {code}

            in the same way they're done in MySQL 8. See MySQL docs at:
            https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
            https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html#optimizer-hints-table-level

            The logic for enabling the hints is expected to be very basic - hook at the same place where the check for optimizer_switch is, override the optimizer_switch setting.
            psergei Sergei Petrunia made changes -
            Summary New-style hint: [NO_]DERIVED_CONDITION_PUSHDOWN, [NO_]MERGE New-style hints: [NO_]DERIVED_CONDITION_PUSHDOWN, [NO_]MERGE
            psergei Sergei Petrunia made changes -
            Description Implement table-level hints:
            {code}
            MERGE, NO_MERGE
            DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN
            {code}

            in the same way they're done in MySQL 8. See MySQL docs at:
            https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
            https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html#optimizer-hints-table-level

            The logic for enabling the hints is expected to be very basic - hook at the same place where the check for optimizer_switch is, override the optimizer_switch setting.             		Implement table-level hints:
            {code}
            MERGE, NO_MERGE
            DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN
            {code}

            in the same way they're done in MySQL 8. See MySQL docs at:
            https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
            https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html#optimizer-hints-table-level

            The logic for enabling the hints is expected to be very basic - hook at the same place where the check for optimizer_switch is, override the optimizer_switch setting.

            The code to base on is MDEV-35504, look at other similar level hints and copy the approach.
            Gosselin Dave Gosselin made changes -
            Assignee Dave Gosselin [ JIRAUSER52216 ]
            Gosselin Dave Gosselin made changes -
            Fix Version/s 12.0 [ 29945 ]
            Gosselin Dave Gosselin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            Gosselin Dave Gosselin made changes -
            Assignee Dave Gosselin [ JIRAUSER52216 ] Oleg Smirnov [ JIRAUSER50405 ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            Gosselin Dave Gosselin made changes -
            Assignee Oleg Smirnov [ JIRAUSER50405 ] Dave Gosselin [ JIRAUSER52216 ]
            Gosselin Dave Gosselin made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            Gosselin Dave Gosselin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            Gosselin Dave Gosselin made changes -
            Assignee Dave Gosselin [ JIRAUSER52216 ] Oleg Smirnov [ JIRAUSER50405 ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            Gosselin Dave Gosselin made changes -
            Assignee Oleg Smirnov [ JIRAUSER50405 ] Dave Gosselin [ JIRAUSER52216 ]
            Gosselin Dave Gosselin made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            Gosselin Dave Gosselin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 12.1 [ 29992 ]
            Fix Version/s 12.0 [ 29945 ]
            Gosselin Dave Gosselin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            julien.fritsch Julien Fritsch made changes -
            julien.fritsch Julien Fritsch made changes -
            julien.fritsch Julien Fritsch made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            Gosselin Dave Gosselin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]

            People

              Gosselin Dave Gosselin
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.