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

CONVERT_IF_BIGGER_TO_BLOB makes temp. table use Aria, which hits the disk

    XMLWordPrintable

Details

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

    Description

      In 5.3 derived_merge was passing the CONVERT_IF_BIGGER_TO_BLOB and would force the optimizer not to produce on disk temporary table . It stopped working in 5.5

      I have documented the issue here :
      http://varokism.blogspot.fr/2011/12/back-on-disk-temporary-tables.html

      At that time no test case have been produce and merging may have break this improvement.

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. MDEV-19 Memory tables: VARCHAR and BLOB support

          • Major - Major loss of function.
          • Stalled

          Activity

            People

              Unassigned Unassigned
              stephane@skysql.com VAROQUI Stephane
              Votes:
              2 Vote for this issue
              Watchers:
              7 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.