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

mariadb-import: delay creation of secondary indexes until after data load

Details

    Description

      This should make the load faster, to create index at once, instead of incrementally building it during LOAD DATA INFILE

      The alternative for this is MDEV-34739

      Attachments

        Issue Links

          blocks

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-33188 Enhance mariadb-dump and mariadb-import capabilities similar to MyDumper

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34739 Implement DISABLE KEYS/ENABLE KEYS in Innodb

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            wlad Vladislav Vaintroub added a comment - - edited

            sanja, could you please review changes in bb-11.8-MDEV-34740

            wlad Vladislav Vaintroub added a comment - - edited sanja , could you please review changes in bb-11.8-MDEV-34740
            sanja Oleksandr Byelkin added a comment -

            All is good, 3 improvement required:

            1. move unittest to other unittests (it is really good that you made the uinittest)
            2. rebease on last 11.8 and add support and tests for VECTOR
            3. fix alone space
            sanja Oleksandr Byelkin added a comment - All is good, 3 improvement required: move unittest to other unittests (it is really good that you made the uinittest) rebease on last 11.8 and add support and tests for VECTOR fix alone space
            lstartseva Lena Startseva added a comment -

            Testing done, Ok to push.

            Test result on database with ~6Gb size:
            mariadb-impot runs with --parallel=5

            Parameter value Execution time
            --innodb-optimize-keys=0 354m15,190s
            --innodb-optimize-keys=1 2m37,144s
            lstartseva Lena Startseva added a comment - Testing done, Ok to push. Test result on database with ~6Gb size: mariadb-impot runs with --parallel=5 Parameter value Execution time --innodb-optimize-keys=0 354m15,190s --innodb-optimize-keys=1 2m37,144s

            People

              wlad Vladislav Vaintroub
              wlad Vladislav Vaintroub
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.