Comments - TokuDB Differences
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.
Here is a simple one liner to check the compression format of the TokuDB data files using the tokuftdump tool :
(don't forget to ajust to your datadir path if its not /var/lib/mysql)
The integer corresponds to the compression format, 0 is uncompressed, 8 is ZLIB and 10 is LZMA, the other format correspondances can be found on make_tdb.cc
On MariaDB5.5.37, the column "dictionary" has changed for "table_dictionary_name", so the right command is now :
Also note that the ZLIB compressed tables are having the value of 11 and not 8 as stated previously.
Hi, it does not work for me. Versions : tokudb_version - 5.6.26-74.0 , version mariaDB - 10.1.10-MariaDB-1jessie-log.
I've added --header to tokuftdump command. Finally it works for me :
And i noticed that changing compression method changes size of table on disk. But command
shows the same size of tables for different compression methods. Why ?