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

ALTER TABLE ADD INDEX - PROCESSLIST - PROGRESS NOT RIGHT (extend progress report for partitioning)

    XMLWordPrintable

Details

    Description

      Hi guys, i was running some ALTER TABLE xxx ADD KEY yyy (zzz)
      and watching status from
      SELECT time_ms/1000,state,info,stage,max_stage,progress FROM information_schema.processlist WHERE info!=''

      and i get 4 status:
      1)COPYING TO TMP TABLE
      2)REPAIR BY SORTING
      3)CREATING INDEX
      4)REPAIR BY SORTING

      to problema is stage/progress
      the max_stage was = 2 while running 1,2
      when it started 3,4 the stage,max_stage and progress was set to 0
      in other words, the max_stage was 'calculated' wrong at stage 1 and 2, it should be 4 instead of 2
      in stage 3,4 the stage, max_stage and progress couldn't help showing the progress of operation (i can't know how many time or progress i will wait)

      my table have about 1,5GB of data, in a small table i couldn't see this since it's really fast

      thankx

      Attachments

        Activity

          People

            Unassigned Unassigned
            rspadim roberto spadim
            Votes:
            1 Vote for this issue
            Watchers:
            4 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.