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

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

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Fix Version/s: 10.3.2
    • Component/s: OTHER
    • Labels:
      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

              Assignee:
              svoj Sergey Vojtovich
              Reporter:
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: