EmergencyEMERGENCY? Get 24/7 Help Now!

Thoughts on Small Datum – Part 2

 | April 29, 2014 |  Posted In: Tokutek, TokuView

If you did not read my first blog post about Mark Callaghan’s (@markcallaghan) benchmarks as documented in his blog, Small Datum, you may want to skim through it now for a little context. ——————- On March 11th, Mark, a former Google and now Facebook database guru, published an insertion rate benchmark comparing MySQL outfitted with […]

Read More

Three Ways that Fractal Tree Indexes Improve SSD for MySQL

 | September 27, 2012 |  Posted In: Tokutek, TokuView

Since Fractal Tree indexes turn random writes into sequential writes, it’s easy to see why they offer a big advantage for maintaining indexes on rotating disks. It turns out that that Fractal Tree indexing also offers signficant advantages on SSD. Here are three ways that Fractal Trees improve your life if you use SSDs. Advantage […]

Read More

Announcing TokuDB v6.5: Optimized for Flash

 | September 25, 2012 |  Posted In: Tokutek, TokuView

We are excited to announce TokuDB® v6.5, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB. This version offers optimization for Flash as well as more hot schema change operations for improved agility. We’ll be posting more details about the new features and performance, so here’s an overview of what’s in store. […]

Read More

Benchmarking single-row insert performance on Amazon EC2

 | May 16, 2012 |  Posted In: Benchmarks, Cloud and MySQL, Cloud and NoSQL, Insight for DBAs, MySQL

I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and effective tool iiBench which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was originally built is long over, […]

Read More

1 Billion Insertions – The Wait is Over!

 | January 26, 2012 |  Posted In: Tokutek, TokuView

iiBench measures the rate at which a database can insert new rows while maintaining several secondary indexes. We ran this for 1 billion rows with TokuDB and InnoDB starting last week, right after we launched TokuDB v5.2. While TokuDB completed it in 15 hours, InnoDB took 7 days. The results are shown below. At the end of […]

Read More

Compression Benchmarking: Size vs. Speed (I want both)

 | September 15, 2011 |  Posted In: Tokutek, TokuView

I’m creating a library of benchmarks and test suites that will run as part of a Continuous Integration (CI) process here at Tokutek. My goal is to regularly measure several aspects of our storage engine over time: performance, correctness, memory/CPU/disk utilization, etc. I’ll also be running tests against InnoDB and other databases for comparative analysis. […]

Read More