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

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

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

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29913 Assertion `thd->stmt_arena != thd->progress.arena' failed in thd_progress_init upon bulk load

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            kolbe Kolbe Kegel (Inactive) created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Assignee Jan Lindström [ jplindst ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 39818 ] MariaDB v2 [ 42690 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.1.0 [ 12200 ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.1.1 [ 16801 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 42690 ] MariaDB v3 [ 64204 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 64204 ] MariaDB v4 [ 132334 ]
            marko Marko Mäkelä made changes -

            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.