EmergencyEMERGENCY? Get 24/7 Help Now!

Real World Compression

 | August 1, 2012 |  Posted In: Tokutek, TokuView

Benchmarking is a tricky thing, especially when it comes to compression. Some data compresses quite well while other data does not compress at all. Storing jpeg images in a BLOB column produces 0% compression, but storing the string “AAAAAAAAAAAAAAAAAAAA” in a VARCHAR(20) column produces extremely high (and unrealistic) compression numbers. This week I was assisting […]

Read More

TokuDB v6.0: Download Available

 | April 30, 2012 |  Posted In: Tokutek, TokuView

TokuDB v6.0 is full of great improvements, like getting rid of slave lag, better compression, improved checkpointing, and support for XA. I’m happy to announce that TokuDB v6.0 is now generally available and can be downloaded here. Sysbench Performance I wanted to take this time to talk about one more under-the-hood goody we’ve added to […]

Read More

TokuDB v6.0: Even Better Compression

 | April 11, 2012 |  Posted In: Tokutek, TokuView

A key feature of our new TokuDB v6.0 release, which I have been blogging about this week, is compression. Compression is always on in TokuDB, and the compression we’ve achieved in the past has been quite good. See a previous post on the 18x compression achieved by TokuDB v5.0 on one benchmark. In our latest […]

Read More

MySQL Conference and Expo Talk on Benchmarking

 | February 2, 2012 |  Posted In: Tokutek, TokuView

I’ll be speaking on April 11th at 4:30 pm in Room 4 in at the Percona Conference and Expo Talk. The topic will be “Creating a Benchmark Infrastructure That Just Works.” Throughout my career I’ve been involved with maintaining the performance of database applications and therefore created many benchmark frameworks. At Tokutek, an important part […]

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