Comments on: Converting an OLAP database to TokuDB, part 1 https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1 Blog by Shlomi Noach Mon, 14 Oct 2013 10:05:02 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Converting an OLAP database to TokuDB, part 3: operational stuff | code.openark.org https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1/comment-page-1#comment-220900 Mon, 14 Oct 2013 10:05:02 +0000 https://shlomi-noach.github.io/blog/?p=6473#comment-220900 […] Converting an OLAP database to TokuDB, part 1 […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1/comment-page-1#comment-219148 Tue, 17 Sep 2013 09:11:05 +0000 https://shlomi-noach.github.io/blog/?p=6473#comment-219148 @Peter,

Thanks for all this info. I am not familiar with it — passing to our operations groups for review.

]]> By: Peter (Stig) Edwards https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1/comment-page-1#comment-218756 Tue, 10 Sep 2013 13:27:23 +0000 https://shlomi-noach.github.io/blog/?p=6473#comment-218756 Hello Shlomi and thank you for the write-ups, both part 1 and 2.

As you mentioned the machine is a Dell Inc. PowerEdge R510 and the workload is likely CPU heavy because of the compression…

The Dell BIOS for PowerEdge R510 needs to be Version 1.9.0 for the Intel Xeon Processor 5600 Series B1 stepping microcode fix.
For code where CPU frequency stepping settings or latency can limit performance you may want to check the bios version with

/opt/dell/srvadmin/bin/omreport chassis bios

and the power profile with:

/opt/dell/srvadmin/bin/omreport chassis pwrmanagement config=profile

as root you can set the power profile (on next reboot) with:

/opt/dell/srvadmin/bin/omconfig chassis pwrmanagement config=profile profile=maxperformance

If you do update the bios then watch out for the power profile settings reverting to the default.

http://downloads.dell.com/FOLDER00792833M/1/PER510-011100BIOS.TXT

Sorry if this is old hat and somewhat off topic, I thought it may be of interest if it was news to you.

]]> By: Converting an OLAP database to TokuDB, part 2: the process of migration | code.openark.org https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1/comment-page-1#comment-218681 Mon, 09 Sep 2013 03:29:43 +0000 https://shlomi-noach.github.io/blog/?p=6473#comment-218681 […] Converting an OLAP database to TokuDB, part 1 […]

]]> By: Rich Prohaska https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1/comment-page-1#comment-218369 Tue, 03 Sep 2013 19:33:27 +0000 https://shlomi-noach.github.io/blog/?p=6473#comment-218369 Are TokuDB tables portable? It depends.

Can I take a backup of the MySQL data directory, copy it to another machine, and start MySQL up with it? Yes.

Can I copy some (not all) of the TokuDB files from the MySQL data directory to another machine? No. Since TokuDB is transactional, the state of the table is not completely contained within the data files for a table. The TokuDB recovery log is also needed. Plus there is some additional meta data that would be required.

We have though about a way to export a table (or all of the tables in a database) and importing it into another MySQL instance, but it is not yet supported.

Can I move a copy of a TokuDB database from an amd64 architecture to some other machine architecture? I don’t know; we never tried it. In addition, I don’t know if TokuDB file constructed on amd64 arch will work on a i386 arch machine.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1/comment-page-1#comment-218367 Tue, 03 Sep 2013 19:08:25 +0000 https://shlomi-noach.github.io/blog/?p=6473#comment-218367 @Edmar, I don’t actually know – best wait for authoritative answer or ask on google groups.

]]> By: Edmar https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1/comment-page-1#comment-218365 Tue, 03 Sep 2013 18:47:13 +0000 https://shlomi-noach.github.io/blog/?p=6473#comment-218365 Wow, Thanks!

Can you comment whether TokuDB tables/databases are portable? Like MyISAM is.

]]> By: Tim Callaghan https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1/comment-page-1#comment-218352 Tue, 03 Sep 2013 12:06:24 +0000 https://shlomi-noach.github.io/blog/?p=6473#comment-218352 Nice write-up, I’m looking forward to the coming results and analysis.

We have the KEY_BLOCK_SIZE issue fixed and coming in the next version of TokuDB (https://github.com/Tokutek/ft-engine/issues/58).

]]>