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

InnoDB Online DDL can fail when tmpdir is small

    XMLWordPrintable

Details

    Description

      When using:

      ALTER TABLE foo ADD INDEX bar (a,b), ALGORITHM=INPLACE, LOCK=NONE

      The global tmpdir will be used instead of the datadir for sorts, which might be too small or too slow to complete the action.

      This is fixed upstream in InnoDB 5.6.29:

      https://bugs.mysql.com/bug.php?id=73250

      A workaround is to use ALGORITHM=COPY but then LOCK=NONE is not supported

      Attachments

        Activity

          People

            Unassigned Unassigned
            mg MG
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.