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

Faster UNIQUE key generation with ALTER TABLE

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Fix Version/s: 10.0.1
    • Component/s: None
    • Labels:
      None

      Description

      Generate also unique keys by sorting (as we do with non unique keys) to speed up alter tables with unique keys significantly.

      This task is for doing this for MyISAM and Aria tables

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              igor Igor Babaev added a comment -

              You reassigned the task to yourself on 10-11-2012 (probably for review) and put it actually on hold.
              What's the reason for it?

              Show
              igor Igor Babaev added a comment - You reassigned the task to yourself on 10-11-2012 (probably for review) and put it actually on hold. What's the reason for it?
              Hide
              serg Sergei Golubchik added a comment -

              Right, I reassigned it to myself for a review. It's on hold, because this task is for 10.0.1 and we haven't released 10.0.0 yet. Any 10.0.1 task has lower priority than releasing 10.0.0. As soon as 10.0.0 will be out I'll start working on my 10.0.1 tasks (and this is one of them)

              Show
              serg Sergei Golubchik added a comment - Right, I reassigned it to myself for a review. It's on hold, because this task is for 10.0.1 and we haven't released 10.0.0 yet. Any 10.0.1 task has lower priority than releasing 10.0.0. As soon as 10.0.0 will be out I'll start working on my 10.0.1 tasks (and this is one of them)
              Hide
              serg Sergei Golubchik added a comment -

              pushed in 10.0-base

              Show
              serg Sergei Golubchik added a comment - pushed in 10.0-base

                People

                • Assignee:
                  igor Igor Babaev
                  Reporter:
                  igor Igor Babaev
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 1 week, 4 days, 7 hours
                    1w 4d 7h