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

Innodb page compression is not working at windows

    XMLWordPrintable

Details

    Description

      Page compression should work out of the box according to the documentation (without additional config). However, it does not work on Windows 11. Here are the steps I do.

      • Download mariadb-11.4.3-winx64
      • Run mariadb-install-db.exe
      • Start with mysqld.exe
      • Set the variable according to the document, innodb_default_row_format='dynamic' & innodb_compression_algorithm='zlib'.
      • Create table with ENGINE=INNODB PAGE_COMPRESSED=1
      • Import data with LOAD DATA INFILE

      Finally I checked the file size and the disk size, they are the same. Also the status variable Innodb_num_page_compressed_trim_op shows 0.

      • I redo the same from Ubuntu 20.04.6 LTS(same mariadb-11.4.3), it works!
      • I also retry the same using mysql (mysql windows), it also works!

      Note

      • For Ubuntu, the size shown by ls and du is different, also innodb_num_page_compressed_trim_op is not 0.
      • For MySQL the file size and disk size are different. I also follow the instructions to format the disk to cluster size 512 bytes. The same disk is used for both Mariadb and MySQL.

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            L M
            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.