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

ALTER TABLE…page_compression_level should not rebuild table

Details

    Description

      The InnoDB table options page_compressed and page_compression_level were introduced in MariaDB 10.1.0.

      An ALTER TABLE operation that changes these attributes unnecessarily causes a full table rebuild. Enabling page_compressed could be done instantaneously (not resulting in immediate space savings). The FORCE keyword could still be used to cause the table to be rebuilt.

      Disabling page_compressed must continue to require the table to be rebuilt.

      The page_compression_level basically matters for compression only, not for the decompression. It should be fine to change the compression level at any time, without any change.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16334 Incorrect ALTER TABLE for changing column option

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-11424 Instant ALTER TABLE of failure-free record format changes

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23199 page_compression flag is missing for full_crc32 tablespace

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25121 innodb_flush_method=O_DIRECT fails on compressed tables

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

          Activity

            marko Marko Mäkelä added a comment -

            We will allow ALGORITHM=INSTANT for changing page_compression_level or setting the page_compressed attribute.

            marko Marko Mäkelä added a comment - We will allow ALGORITHM=INSTANT for changing page_compression_level or setting the page_compressed attribute.

            People

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