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

Monitor progress of ALTER TABLE ... ADD INDEX, ALGORITHM=INPLACE for InnoDB

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.1.1
    • None
    • None

    Description

      When adding an index to an InnoDB table using algorithm=inplace, it is not possible to monitor the progress of the merge sort operation, which can take a great deal of time.

      It would be nice if the "Progress" column of SHOW PROCESSLIST was updated with some information about how far along the merge sort has progressed. It might also be possible or desirable to make some progress information available by other means.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            kolbe Kolbe Kegel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.