Schlomi,
I've never seen this before, can you please give us a little more information:
1. Attach your my.cnf file
2. Include the output of "show variables like 'tokudb%';"
I'm curious to see what your default compression is set to.
-Tim
On Thursday, May 2, 2013 1:06:01 AM UTC-4, Shlomi Noach wrote:
I'm evaluating 5.5.30-tokudb-7.0.1-MariaDB-log after having compiled it from source.
I've attempted ALTERing one table from InnoDB to TokuDB, to have a 4 times increase in volume on disk.
Original table:
CREATE TABLE `logs` (
`n` varchar(20) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`s` varchar(64) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`m` text NOT NULL,
`l` tinyint(11) NOT NULL DEFAULT '0',
`a` char(16) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `appSignature` (`a`),
KEY `n` (`n`,`t`),
KEY `s` (`s`,`t`)
) ENGINE=InnoDB AUTO_INCREMENT=92055455 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4
;
This takes at about 4.7GB on disk; it is in COMPRESSED format. Uncompressed volume is at about 9-10GB
After ALTERing to TokuDB:
mysql> alter table logs engine=tokudb;
Query OK, 66325471 rows affected (7 hours 39 min 20.78 sec)
Records: 66325471 Duplicates: 0 Warnings: 0
Altering took more than 7 hours, to the result of:
-rwxrwx--x 1 mysql mysql 5513439744 2013-04-30 23:55 _myschema_sql_2194_4_key_appSignature_b_1_18_B_1.tokudb
-rwxrwx--x 1 mysql mysql 5483389440 2013-05-01 01:13 _myschema_sql_2194_4_key_name_b_1_18_B_2.tokudb
-rwxrwx--x 1 mysql mysql 5713266688 2013-05-01 02:33 _myschema_sql_2194_4_key_source_b_1_18_B_3.tokudb
-rwxrwx--x 1 mysql mysql 15438368256 2013-04-30 22:38 _myschema_sql_2194_4_main_b_1_18_B_0.tokudb
-rwxrwx--x 1 mysql mysql 65536 2013-04-30 19:08 _myschema_sql_2194_4_status_6_1_18.tokudb
This is after verifying:
mysql> select * from information_Schema.TokuDB_file_map;
+----------------------------------+-----------------------------------------------------------+
| dictionary_name | internal_file_name |
+----------------------------------+-----------------------------------------------------------+
| ./myschema/logs-key-appSignature | ./_myschema_sql_2194_4_key_appSignature_b_1_18_B_1.tokudb |
| ./myschema/logs-key-name | ./_myschema_sql_2194_4_key_name_b_1_18_B_2.tokudb |
| ./myschema/logs-key-source | ./_myschema_sql_2194_4_key_source_b_1_18_B_3.tokudb |
| ./myschema/logs-main | ./_myschema_sql_2194_4_main_b_1_18_B_0.tokudb |
| ./myschema/logs-status | ./_myschema_sql_2194_4_status_6_1_18.tokudb |
| tokudb_meta | ./tokudb_meta_3_0_18.tokudb |
+----------------------------------+-----------------------------------------------------------+
And so TokuDB table amounts to ~17GB on disk.
Makes sense in any way?