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

Add ability to compress existing tables

    XMLWordPrintable

Details

    Description

      MySQL 5.7 is able to compress existing tables by altering the table and then issuing an OPTIMIZE TABLE query:

      ALTER TABLE t1 COMPRESSION="zlib";
      OPTIMZE TABLE t1;

      The alter table command sets the value for new writes, and the optimize table command compresses existing pages.

      source: https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html

      This would be a very nice feature to have for organizations attempting to transition their tables to use compression.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            thomasmaerz Thomas Maerz
            Votes:
            0 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.