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

ALTER TABLE…page_compression_level should not rebuild table

    XMLWordPrintable

    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

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              marko Marko Mäkelä
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: