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:…

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,

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:

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