iiBench with deletes

Published on 29 January 2009 by bradley in TokuView

We modified the iiBench benchmark to perform deletions as well as insertions, and compared InnoDB to Tokutek’s Fractal TreeTM storage engine, both running on MySQL 5.1. I’ll post the revised iiBench tarball soon.
Here is what the performance looks like:

The iiBench-with-deletions benchmark works as follows. The benchmark employs a fact table with an autoincremented [...]

2 comments | Continue Reading

iiBench Fractal Tree Results

Published on 23 January 2009 by bradley in TokuView

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 [...]

0 comments | Continue Reading

iiBench Contest Results

Published on 20 January 2009 by bradley in TokuView

At OpenSQL Camp in November we presented a challenge to insert one billion rows, maintaining indexes, into a MySQL table. The best results we have seen are:

1 comment | Continue Reading

iiBench Contest Updates

Published on 08 January 2009 by bradley in TokuView

We re-ran iiBench based on Mark Callaghan’s excellent work. We used standard InnoDB engine in MySQL 5.1 without the Google or Percona patches. Our hardware is similar to Mark’s except we used a 6-disk hardware RAID 0, whereas Mark employed a 10-disk software RAID 0. We ran on the same hardware as [...]

0 comments | Continue Reading