Comments on: Converting an OLAP database to TokuDB, part 2: the process of migration https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-2-the-process-of-migration Blog by Shlomi Noach Sat, 10 Dec 2016 09:26:50 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Getting to know TokuDB for MySQL https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-2-the-process-of-migration/comment-page-1#comment-246667 Mon, 23 Jun 2014 07:20:14 +0000 https://shlomi-noach.github.io/blog/?p=6530#comment-246667 […] is the compression impact ? Like everything else in MySQL it depends of your schema. Shlomi Noach reported he was able to convert 4 Terabytes worth of uncompressed InnoDB data (or 2 Terabytes of compressed […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-2-the-process-of-migration/comment-page-1#comment-221975 Sun, 27 Oct 2013 10:31:41 +0000 https://shlomi-noach.github.io/blog/?p=6530#comment-221975 No, actually. Without compression I stopped the alter process some 35 hours into the job. So it certainly wasn’t faster.

]]> By: Shantanu Oak https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-2-the-process-of-migration/comment-page-1#comment-221962 Sun, 27 Oct 2013 04:14:19 +0000 https://shlomi-noach.github.io/blog/?p=6530#comment-221962 You mentioned about 40 hours alter time with load_save_space option enabled. How fast it would have been if you had enough disk space? May be 20 hours / 30 hours? Is there any benchmark test on this?

]]> By: TokuDB configuration variables of interest | code.openark.org https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-2-the-process-of-migration/comment-page-1#comment-221660 Wed, 23 Oct 2013 18:05:09 +0000 https://shlomi-noach.github.io/blog/?p=6530#comment-221660 […] load operations (e.g. ALTER TABLE) are compressed or uncompressed. Do yourself a big favour (why? read here) and keep it on. Our setup […]

]]> By: Rich Prohaska https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-2-the-process-of-migration/comment-page-1#comment-218751 Tue, 10 Sep 2013 10:35:50 +0000 https://shlomi-noach.github.io/blog/?p=6530#comment-218751 These crashes were caused when the MySQL server hit its open file limit. TokuDB uses file descriptors differently than other storage engines, so a migration to TokuDB needs to account for this difference. Since we did not document this aspect of TokuDB, I wrote a wiki that describes how TokuDB uses file descriptors.

https://github.com/Tokutek/ft-engine/wiki/File-Descriptors

]]> By: Mark Callaghan https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-2-the-process-of-migration/comment-page-1#comment-218711 Mon, 09 Sep 2013 14:07:47 +0000 https://shlomi-noach.github.io/blog/?p=6530#comment-218711 Thanks for all of the details.

]]> By: George https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-2-the-process-of-migration/comment-page-1#comment-218693 Mon, 09 Sep 2013 07:13:42 +0000 https://shlomi-noach.github.io/blog/?p=6530#comment-218693 Thanks for sharing your experiences. Was a very informative read indeed 🙂

]]>