Comments on: Converting compressed InnoDB tables to TokuDB 7.0.1 https://shlomi-noach.github.io/blog/mysql/converting-compressed-innodb-tables-to-tokudb-7-0-1 Blog by Shlomi Noach Fri, 12 Jul 2013 12:04:29 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/converting-compressed-innodb-tables-to-tokudb-7-0-1/comment-page-1#comment-214499 Fri, 12 Jul 2013 12:04:29 +0000 https://shlomi-noach.github.io/blog/?p=6368#comment-214499 I’m now at the process of comparing TokuDb performance with that of InnoDB on a DWH machine. Will update.

]]> By: grails mysql guy https://shlomi-noach.github.io/blog/mysql/converting-compressed-innodb-tables-to-tokudb-7-0-1/comment-page-1#comment-214493 Fri, 12 Jul 2013 08:53:48 +0000 https://shlomi-noach.github.io/blog/?p=6368#comment-214493 I haven’t tried TokuDB before. Seems reduction in filse size is so good. Will this affect performance comparing with InnoDB too?

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/converting-compressed-innodb-tables-to-tokudb-7-0-1/comment-page-1#comment-211728 Wed, 05 Jun 2013 14:13:45 +0000 https://shlomi-noach.github.io/blog/?p=6368#comment-211728 Justin,

It does not. Just doing so from within InnoDB, changing the KEY_BLOCK_SIZE, shows that indexes are still with previous key block size.

(PS, have edited your comment to include comma before “FORCE”)

]]> By: Justin Swanhart https://shlomi-noach.github.io/blog/mysql/converting-compressed-innodb-tables-to-tokudb-7-0-1/comment-page-1#comment-211719 Wed, 05 Jun 2013 13:43:46 +0000 https://shlomi-noach.github.io/blog/?p=6368#comment-211719 What about:
alter table t engine=tokudb row_format=tokudb_lzma key_block_size=0, FORCE;

Does that rebuild the indexes?

]]>