Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27228 Deprecate Spider plugin variables that result in excessive tweak
  3. MDEV-27923

Deprecate spider_use_handler

Details

    Description

      Passing a Handler statement to backend data nodes without converting it to SQL sometimes improves the performance. However, only a few people use Handler statements and the performance gain seems not to be very significant. Further, setting spider_use_handler > 0 disables the GROUP BY handler.

      Attachments

        Issue Links

          blocks

          Technical task - A technical task. MDEV-27256 Delete spider_use_handler and related code

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment -

            https://github.com/MariaDB/server/commit/b034b416b2cfebe649db787de0f5a14da8091b12

            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - https://github.com/MariaDB/server/commit/b034b416b2cfebe649db787de0f5a14da8091b12
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - - edited

            I should have taken care of the table value "uhd".

            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - - edited I should have taken care of the table value "uhd".
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - - edited

            And, I needed to disable test spider/handler.*.

            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - - edited And, I needed to disable test spider/handler.* .
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment -

            Please review the patch below. The variable and the related code will be deleted in 10.9 or at least 10.10.

            https://github.com/MariaDB/server/commit/531e4395c3ccf68a77ceab4d19138a85809254d6

            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - Please review the patch below. The variable and the related code will be deleted in 10.9 or at least 10.10. https://github.com/MariaDB/server/commit/531e4395c3ccf68a77ceab4d19138a85809254d6
            holyfoot Alexey Botchkov added a comment -

            ok to push.

            holyfoot Alexey Botchkov added a comment - ok to push.

            People

              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.