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

Extend EXPLAIN to provide hint about whether FILESORT will likely fit in memory or write to disk

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      When developers run EXPLAIN to find out if the query will be okay to run or not, the "filesort" in "extra info" is not clear about whether that is likely to be an in-buffer sort, or if it is a spill-to-disk sort. Perhaps (based on the row size, estimated rows involved, buffer size) a good guess can be added to the explain output.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Eric_Herman Eric Herman
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.