Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.11, 11.2, 11.4, 11.3.2
-
windows 11 Pro, 23H2
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.