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

document "Using buffer" in extras of explain output - https://mariadb.com/kb/en/mariadb/explain/

    XMLWordPrintable

Details

    Description

      From slow query log:

      # Thread_id: 161  Schema: hotspot  QC_hit: No
      		 
      # Query_time: 17.934323  Lock_time: 0.000119  Rows_sent: 0  Rows_examined: 4
      		 
      #
      		 
      # explain: id   select_type     table   type    possible_keys   key     key_len ref     rows    Extra
      		 
      # explain: 1    SIMPLE  radacct range   AcctSessionId,UserName_AcctSessionId,UserStop   UserName_AcctSessionId  52      NULL    1       Using where; Using buffer
      		 
      #
      		 
      SET timestamp=1443470903;
      		 
      UPDATE radacct        ....

      Got same query plan with explain:

      Found in slow query log. Tried to look up what "Using buffer" on https://mariadb.com/kb/en/mariadb/explain/ actually mean and couldn't see an explanation.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9133 range chosen for update while ref used for select on multicolumn index with length

          • Major - Major loss of function.
          • Closed

          Activity

            People

              greenman Ian Gilfillan
              danblack Daniel Black
              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.