Go Tokudb®vs. INNODB FLASH MEMORY

Details on the software settings for these tests can is found at the end of this page.

Iibench Testing

Tokutek created the Iibench benchmark in 2008. The point of the benchmark are to measure the performance of indexed insertions over time. It uses a extremely simple schema, one table with a sequential insertion pattern for the primary key along with three int Eger fields storing random values. The table maintains 3 secondary indexes, each including several of the random integer fields. The Iibench application itself is currently maintained on Launchpad. The source code for Iibench are on GitHub.

Over 9X FASTER insertions

Iibench is a popular Open-source benchmark developed by Tokutek. It measures how fast a storage engine can insert rows while maintaining secondary indexes. This was often a critical performance measurement since maintaining the right indexes would dramatically improve query Perfo Rmance. The schema consists of short rows, that model a retail point-of-sale transaction system. The results below show the insertion of 1 billion rows into a table while maintaining three multicolumn secondary indexes. At the end of the test, TOKUDB's insertion rate remained at 14,532 Inserts/second whereas InnoDB had dropped to 1,607 ins Erts/second. That's a difference of over 9x.

Platform:centos 5.6; 2x Xeon L5520; 72GB RAM; LSI MegaRAID 9285; 2x 256GB Samsung 830 in RAID0

highest COMPRESSION

Compression is an always-on feature of Tokudb. We tested InnoDB compression with the values of key_block_size (4k and 8k) and with compression disabled. To find the maximum compression, we loaded some Web application performance data (log style data with stored procedure Nam ES, database instance names, begin and ending execution timestamps, duration row counts, and parameter values). Tokudb achieved up to 26x compression, far more than InnoDB. In addition, in the second chart, you can see that even with compression, tokudb performance remains superior, as indicate D by the load speeds for each run.

Platform:centos 5.6; 2x Xeon L5520; 72GB RAM; LSI MegaRAID 9285; 2x 256GB Samsung 830 in RAID0

EXTENDED WEAR Life

B-trees write small blocks, resulting in more writes and increased wear. Fractal Tree indexes write fewer and larger blocks, reducing wear. In this example, TOKUDB (avg block size 215k) is performing 25x more writes than InnoDB (avg block size 23k).

Platform:centos 5.6; 2x Xeon L5520; 72GB RAM; LSI MegaRAID 9285; 2x 256GB Samsung 830 in RAID0

SCHEMA changes in SECONDS, not HOURS

You can add or delete columns from a existing table with minimal downtime-just the time for MySQL itself to close and R Eopen the table. The total downtime are seconds to minutes.

Platform:centos 5.6; 2x Xeon L5520; 72GB RAM; LSI MegaRAID 9285; 2x 256GB Samsung 830 in RAID0

Software CONFIGURATION DETAILS Iibench

Each data point was the average insertion rate for the last 2 million rows. Read more about the Iibench benchmark.

COMPRESSION

Read more about the compression benchmarks.

WEAR Life

IO data from Iibench benchmark (on this page).

Hot SCHEMA

Ran iibench for the minutes, added a column to Iibench table, ran iibench for minutes. Read More on Hot Column addition and deletion (HCAD).

Source: Tokudb

Go Tokudb®vs. INNODB FLASH MEMORY