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

            Activity

              People

              Assignee:
              greenman Ian Gilfillan
              Reporter:
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: