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

          duplicates

          Task - A task that needs to be done. MDEV-18508 create index cannot be done in parallel

          • Major - Major loss of function.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-16264 Implement a common work queue for InnoDB background tasks

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26740 Inplace alter rebuild increases file size

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35170 Merge applicable changes from InnoDB 8.0.40

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Task - A task that needs to be done. MDEV-5171 Add support for --innodb-optimize-keys to mysqldump.

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-11675 Lag Free Alter On Slave

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-16223 Background ADD INDEX

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-24621 In bulk insert, pre-sort and build indexes one page at a time

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32174 ROW_FORMAT=COMPRESSED table corruption due to ROLLBACK

          • Critical - Crashes, loss of data, severe memory leak.
          • In Testing

          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.