Comments - InnoDB Page Compression

ok finally upgrade to 10.11

Server version: 10.1.11-MariaDB-1wheezy - mariadb.org binary distribution

Please read the documentation on this page: Choosing compression algorithm. You do not have lz4 available on your system, so either need to install and compile, or far easier is choose one that's available, probably zlib.

but i have lz4 installed when i type lz4 -V i get

* LZ4 command line interface 64-bits r128, by Yann Collet (Feb 13 2016) *

Yes, but they have not all been compiled into MariaDB, so either you need to recompile MariaDB with the extra compression algorithms, or use one already there.

ok can you please tell me how can i compile lz4 into mariaDB .... i mean that recompiling thing how to do , and how to pass lz4 .

thanks it will help others too , because on stackoverflow maria DB experts are none.

cmake .
grep LZ4 CMakeCache.txt

should contain:

ITH_INNODB_LZ4:STRING=AUTO
HAVE_LZ4_H:INTERNAL=1
HAVE_LZ4_SHARED_LIB:INTERNAL=1

make -j4
sudo make install

done ........... :)

i run again make install

in output displaying all files Up-to-date restarted mysql server too but no success getting error

Variable 'innodb_compression_algorithm' can't be set to the value of 'lz4'

recompiled as instructed above and installed it again but still get same error

Variable 'innodb_compression_algorithm' can't be set to the value of 'lz4'

hmmm so that mean i need to download maraidb 10.11 source

and then run above commands

so before running sudo make install , should i uninstall current version or what. i mean i have running 10.11 so if recompile and install over it custom build then should it will not create any problem ?