The Ultimate Guide to High Availability with MariaDB

Comments - TokuDB Differences

8 years, 2 months ago Sergei Khomutov
Re: Check the compression format of the tables
This comment has the status of 'removed' and can only be seen by you.

Hi, this not work for me. Versions : tokudb_version - 5.6.26-74.0 , version mariaDB - 10.1.10-MariaDB-1jessie-log. How can i check compression method and alter them on table ? I try "Alter table Costs COMPRESSION = tokudb_quicklz; " but this does'n work. Size of table still the same.

 
8 years, 2 months ago Sergei Khomutov
Re: Check the compression format of the tables

I've added --haeder to tokuftdump to command. This work for me :

{ mysql -sNe 'SELECT dictionary_name, internal_file_name FROM information_schema.tokudb_file_map WHERE table_dictionary_name = "main" OR table_dictionary_name LIKE "key-%"' |perl -F'\t' -ane '@out=qx(tokuftdump --nodata --header --rootnode /var/lib/mysql/$F[1]); foreach $ftdump (@out) { if($ftdump=~/^ compression_method=([0-9]+)$/) { print $F[0]."\t".$1."\n"; last } }'

Wich method corresponds to number 9 , 10 ?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.