Sample Header Ad - 728x90

how do I set the compression level in tokudb

1 vote
0 answers
608 views
Tokudb has various algorithms, lmza, zlib, zstd etc . These algorithms have the ability to be configured. In that, you can set the compression level to a value between 1 and 10 depending on the algorithm. How do I do this when creating a table using one of those compression algorithms, https://www.percona.com/doc/percona-server/LATEST/tokudb/using_tokudb.html#tokudb-compression https://www.percona.com/blog/2016/03/09/evaluating-database-compression-methods/ MariaDB [test]> create table t_zlib (x int, y int) compression=tokudb_zlib; MariaDB [test]> show create table t_zlib; CREATE TABLE t_zlib ( x int(11) DEFAULT NULL, y int(11) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 compression=tokudb_zlib
Asked by nelaaro (767 rep)
Aug 22, 2017, 09:41 AM