Author Archives: Rich Prohaska

Speeding Up TPCC Table Loads by 8x with TokuDB...

Posted on June 17, 2011 by Rich Prohaska

Percona’s TPCC for MySQL toolset allows one to measure the query performance for an OLTP workload on various MySQL storage engines. The toolset includes a program to load the database tables, and a program to run queries and measure…

Leave a comment

Loading Air Traffic Control Data with TokuDB 4.1.1

Posted on August 27, 2010 by Rich Prohaska

TokuDB has a big advantage over B-trees when trickle loading data into existing tables. However, it is possible to preprocess the data when bulk loading into empty tables or when new indexes are created. TokuDB release 4 now uses a…

7 Comments

TokuDB speeds up “replace” and...

Posted on August 3, 2010 by Rich Prohaska

In posts on June 30 and July 6, we explained how implementing the commands “replace into” and “insert ignore” with TokuDB’s fractal trees data structures can be two orders of magnitude faster than implementing them with B-trees.…

Leave a comment

MariaDB and the MySQL Sandbox

Posted on July 26, 2010 by Rich Prohaska

Tokutek tests its TokuDB Fractal Tree storage engine with multiple MySQL distributions. We make extensive use of the MySQL Sandbox in our test automation. We tweaked the regular expressions that match binary tarball names in the MySQL Sandbox so that…

Leave a comment

High Insertion Rates into a TokuDB Table with...

Posted on January 5, 2010 by Rich Prohaska

We recently made transactions in TokuDB 3.0 durable. We write table changes into a log file so that in the event of a crash, the table changes up to the last checkpoint can be replayed. Durability requires the log file…

Comments Off