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

Add Spider status variable to count usage of GROUP BY handler

    XMLWordPrintable

Details

    Description

      The Spider storage engine has status variables for counting the number of times direct UPDATE and direct DELETE. https://mariadb.com/kb/en/spider-status-variables/#spider_direct_delete

      It would be convenient that there is a status variable to count the number of times the direct SELECT is performed (i.e., GROUP BY handler is used). Currently, a user can distinguish direct SELECT and non-direct SELECT by the result of EXPLAIN, but this is not consistent and makes it difficult to collect statistics about the direct SELECT.

      From the consistency viewpoint, the name of the status variable would be Spider_direct_select or Spider_group_by_handler.

      Attachments

        Issue Links

          Activity

            People

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