New TokuDB v5.2
TokuDB® v5.2 is a drop-in replacement for InnoDB that scales MySQL® from GBs to TBs while improving insert speed, query performance, compression, and online schema flexibility. Uses standard SQL and supports ACID and MVCC.
Author Archives: bradley
I forgot to include the titles for my talks.
The ignite talk Wednesday at 7pm is “What Is a Performance Model for SSDs?“
The ignite talk is a 5-minute talk at tonight’s Ignite MySQL session organized by Brian…
I (Bradley C. Kuszmaul) am presenting two talks at the MySQL User Conference.
The first talk is a 5-minute talk at tonight’s Ignite MySQL session organized by Brian Aker. I’ll present some performance measurements on the Intel X25E SSD.…
I saw Mark Callaghan’s post, and his graph showing miss rate as a function of cache size for InnoDB running MySQL. He plots miss rate against cache size and compares it to two simple models:
A linear model where…
We’re supporting the OpenSQL Camp, which will be held in Portland on November 14.
One of my objectives for the camp is to make progress on a universal storage engine API, to make it possible to use…
Sorting a Terabyte in 197 seconds
I just returned from The 21st ACM Symposium on Parallelism in Algorithms and Architectures (SPAA), held in Calgary, where I gave a talk about my entry to the sorting contest. I sorted…
In this post I’m going to talk about how TokuDB’s implementation of auto increment works, and contrast it to the behavior of MyISAM and InnoDB. We feel that the TokuDB behavior is easier to understand, more standard-compliant and offers higher…
Summary: An alternate approach, offered in response to our original post, provides excellent improvements for smaller databases, but clustered indexes offer better performance as database size increases. (This posting is by Dave.)
Jay Pipes suggested an alternate approach…
Executive Summary: A query like TPC-H Query 17 can be sped up by large factors by using straight_joins and clustering indexes. (This entry posted by Dave.)
In a previous post, we wrote about queries like TPC-H query 2,…
In this post we’ll describe a query that accrued significant performance advantages from using a relatively long index key. (This posting is by Zardosht and Bradley.)
We ran across this query recently when interacting with a customer (who gave…
