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

Add status variable that lists supported page compression algorithms

Details

    Description

      InnoDB page compression is a bit awkward, because it supports a bunch of different page compression algorithms, but every build doesn't support every compression algorithm.

      There is not really a great way to check which page compression algorithms a specific build supports.

      https://mariadb.com/kb/en/library/compression/#checking-which-page-compression-algorithms-are-supported

      Maybe we should add a status variable that contains a list of supported page compression algorithms?

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20672 Usage message for innodb_compression_algorithm system variable is missing "snappy"

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Task - A task that needs to be done. MDEV-18586 Clarify benefits of compression methods (ROW_FORMAT=COMPRESSED vs PAGE_COMPRESSED=1)

          • Major - Major loss of function.
          • Closed

          Activity

            GeoffMontee Geoff Montee (Inactive) added a comment -

            There are actually already individual status variables for each compression algorithm:

            SHOW GLOBAL STATUS WHERE Variable_name IN ('Innodb_have_lz4', 'Innodb_have_lzo', 'Innodb_have_lzma', 'Innodb_have_bzip2', 'Innodb_have_snappy');
            		 
            +--------------------+-------+
            		 
            | Variable_name      | Value |
            		 
            +--------------------+-------+
            		 
            | Innodb_have_lz4    | OFF   |
            		 
            | Innodb_have_lzo    | OFF   |
            		 
            | Innodb_have_lzma   | ON    |
            		 
            | Innodb_have_bzip2  | OFF   |
            		 
            | Innodb_have_snappy | OFF   |
            		 
            +--------------------+-------+
            		 
            5 rows in set (0.001 sec)

            GeoffMontee Geoff Montee (Inactive) added a comment - There are actually already individual status variables for each compression algorithm: SHOW GLOBAL STATUS WHERE Variable_name IN ('Innodb_have_lz4', 'Innodb_have_lzo', 'Innodb_have_lzma', 'Innodb_have_bzip2', 'Innodb_have_snappy'); +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_have_lz4 | OFF | | Innodb_have_lzo | OFF | | Innodb_have_lzma | ON | | Innodb_have_bzip2 | OFF | | Innodb_have_snappy | OFF | +--------------------+-------+ 5 rows in set (0.001 sec)

            People

              marko Marko Mäkelä
              GeoffMontee Geoff Montee (Inactive)
              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.