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

Aria Max Table Size for internal on-disk temporary tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.32
    • None
    • None
    • None

    Description

      When a query requires an internal temporary table, and this tables becomes too large to be kept in ram, the table is moved to disk using Aria engine. If the on-disk .MAD file reaches 4GB, an error occurs:

      [ERROR] mysqld: The table '/tmp/#sql_74e_0' is full

      See discussion at https://lists.launchpad.net/maria-discuss/msg00842.html and the original report at https://kb.askmonty.org/en/aria-max-table-size-for-internal-on-disk-temporary-tables/ and

      I can't find an issue for this, so I think it may have been overlooked.

      Attachments

        Activity

          People

            elenst Elena Stepanova
            greenman Ian Gilfillan
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.