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

AliSQL: [Feature] Issue#30 SUPPORT BIG COLUMN COMPRESS

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3.2
    • OTHER
    • None

    Description

      New syntax:
      -----------
      column_definition:
         data_type [NOT NULL | NULL] [DEFAULT default_value]
         [AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY]
         [COMMENT 'string']
         [COLUMN_FORMAT
         {FIXED|DYNAMIC|COMPRESSED|DEFAULT}]
         [STORAGE {DISK|MEMORY|DEFAULT}]
         [reference_definition]
       
      Description:
      ------------
      If the column was defined as a compressed column, then the column data will be
      compressed using zlib. Currently blob/text/varchar/varbinary are supported.
       
      DDL:
      Currently Not allowed to define a index that include compressed
      column, an error message throw(ER_BLOB_KEY_WITH_COMPRESS)
       
      And use COPY algorithm if column_format was changed. So we can't use
      online ddl to change the column format.
       
      Control option:
      innodb_rds_column_compression_level
      innodb_rds_column_zip_threshold
      innodb_rds_column_zlib_strategy
              These variables above are used to control the param for deflate used by
              column data compression.
      innodb_rds_column_zip_threshold
              control the compress threshold, if the data length exceeds this value,
              then compress the data.
      

      https://github.com/alibaba/AliSQL/commit/f9753b591202241cbd9d1a02c2d95e8ce6fdd1a1

      Attachments

        Issue Links

          Activity

            People

              svoj Sergey Vojtovich
              svoj Sergey Vojtovich
              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.