Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 4, 2009
How clustering indexes sometimes help UPDATE and DELETE performance
I recently posted a blog entry on clustering indexes, which are good for speeding up queries. Eric Day brought up [...]
June 1, 2009
Long Index Keys
In this post we’ll describe a query that accrued significant performance advantages from using a relatively long index key. (This [...]
May 28, 2009
Clustering indexes vs. Covering indexes
Yesterday, I (Zardosht) posted an entry introducing clustering indexes. Here, I elaborate on three differences between a clustering index and [...]
May 27, 2009
Introducing Multiple Clustering Indexes
In this posting I’ll describe TokuDB’s multiple clustering index feature. In general (not just for TokuDB) a clustered index or [...]
May 22, 2009
Publications Related to Fractal Tree Indexing
The TokuDB storage engine for MySQL employs Fractal Tree technology. We’ve been planning to write a white paper explaining how [...]
May 14, 2009
Covering Indexes: Orders-of-Magnitude Improvements
The talk I gave at the Percona Performance Conference at the MySQL Users Conference in April 2009 can be found [...]
April 28, 2009
The Depth of a B-tree
Schlomi Noach recently wrote a useful primer on the depth of B-trees and how that plays out for point queries [...]
April 26, 2009
High Anxiety Whenever You’re Near
Every time I visit the Sun Santa Clara Campus, I’m reminded of Mel Brooks’s movie “High Anxiety”. The campus was [...]
April 17, 2009
TokuDB Storage Engine for MySQL
Tokutek officially announced the TokuDB for MySQL v2.0 Storage Engine, v2.0 on April 16th, 2009. TokuDB uses Fractal Tree (TM) [...]
April 10, 2009
Improving TPC-H-like Queries – Q2
Posted by Bradley C. Kuszmaul and David Wells Executive Summary: A MySQL straight join can speed up a query that [...]
March 18, 2009
MySQL insert performance with iiBench Python client
Mark Callaghan recently developed and released an enhanced Python version of Tokutek’s iiBench benchmark (Thanks Mark!). We’re happy to see [...]
January 29, 2009
iiBench with deletes
We modified the iiBench benchmark to perform deletions as well as insertions, and compared InnoDB to Tokutek’s Fractal TreeTM storage [...]
January 23, 2009
iiBench Fractal Tree Results
A few weeks ago I reported InnoDB performance on the iiBench 1-billion row insert test. Today I’m reporting on Tokutek’s [...]
January 20, 2009
iiBench Contest Results
At OpenSQL Camp in November we presented a challenge to insert one billion rows, maintaining indexes, into a MySQL table. [...]
January 8, 2009
iiBench Contest Updates
We re-ran iiBench based on Mark Callaghan’s excellent work. We used standard InnoDB engine in MySQL 5.1 without the Google [...]
December 5, 2008
iiBench configuration
A tip of the hat to Mark Callaghan, who suggested I post our my.cnf settings for iiBench. Instead of fiddling [...]
December 5, 2008
iiBench Contest
I’d like to advertise my previous iiBench posting again (now that we are feeding into PlanetMySQL.)
December 3, 2008
iiBench Contest – Who Can Insert 1B Rows into MYSQL the Fastest?
At the recent OpenSQL Camp in Charlottesville, VA, Tokutek offered a challenge to the MySQL community – who can insert [...]
April 4, 2008
Hacking for Faster Insertions: Is this really how you want to spend your time?
Recall that I’ve claimed that it takes 28 years to fill a disk with random insertions, given a set of [...]
March 11, 2008
Tradeoff: Insertions versus Point Queries
I’ve been waving my hands about lower bounds. Well, sometimes I haven’t been waving my hands, because the lower bounds [...]