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

InnoDB persistent statistics fail to update after ALTER TABLE...ALGORITHM=COPY

    XMLWordPrintable

Details

    Description

      The test case for the following change in MySQL 8.0.37 suggests that MariaDB is affected by the same:
      Bug#35127747 The n_rows value becomes 0 when repeated altering with algorithm=copy within 10 seconds

      That is, for ALTER TABLE...ALGORITHM=COPY the InnoDB statistics will not be updated. This is similar to MDEV-28327, which affected INSERT. Note: I did not test with the MDEV-33087 setting innodb_alter_copy_bulk=ON.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28327 InnoDB persistent statistics fail to update after bulk insert

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33087 ALTER TABLE...ALGORITHM=COPY should build indexes more efficiently

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34672 Merge applicable InnoDB changes from MySQL 8.0.38 and 8.0.39

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

          Activity

            People

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