EmergencyEMERGENCY? Get 24/7 Help Now!

iiBench Fractal Tree Results

 | January 23, 2009 |  Posted In: Tokutek, TokuView

PREVIOUS POST
NEXT POST

A few weeks ago I reported InnoDB performance on the iiBench 1-billion row insert test. Today I’m reporting on Tokutek’s Fractal TreeTM storage engine performance.

We ran iiBench on the same hardware (Sun x4150, 8 cores @ 3.16GHz, 16GB memory, 6 SAS disk HW RAID 0) using Tokutek’s storage engine for MySQL. The performance looks like

Graph of iiBench performance with for Tokutek's fractal-tree based storage engine

Our engine consumed 20.2 hours elapsed time, and inserted the last 10M rows at a rate of 11,220 rows/second. In contrast, InnoDB finished the test in 207.5 hours, inserting the last 10M rows at a rate of 876 rows/second. For our engine, the my.cnf file has no special parameters defined – the test was run with default parameters. By default, Tokutek uses 50% of the physical memory for its buffer pool. That works well for a broad range of physical memory sizes, eliminating the need for tuning parameters in many cases. iiBench sets a single Tokutek-specific variable, tokudb_commit_sync=off, in the client session. Setting this variable defers synchronization of the log files, similar to setting innodb_flush_log_at_trx_commit=2 for InnoDB.

Take a look at our early release program if you’re interested in evaluating the technology.

PREVIOUS POST
NEXT POST

Leave a Reply