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

Implement parallel CREATE INDEX, ALTER TABLE, or bulk load

    XMLWordPrintable

Details

    Description

      ALTER TABLE in InnoDB is single-threaded, except for the special case ADD FULLTEXT INDEX, which creates additional threads to create the partitioned inverted index in shorter time.

      We should refactor ADD FULLTEXT INDEX to make use of the MDEV-16264 work queue and make ADD INDEX use of the background threads as well. To avoid disparity with smaller items in the work queue, the work should be split into smaller items, such as "merge sort 2 blocks" or "copy a sorted block to index pages".

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              marko Marko Mäkelä
              Votes:
              2 Vote for this issue
              Watchers:
              12 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.