Schlomi Noach recently wrote a useful primer on the depth of B-trees… and how that plays out for point queries — in both clustered indexes, like InnoDB, and in unclustered indexes, like MyISAM. Here, I’d like to talk about the

Every time I visit the Sun Santa Clara Campus, I’m reminded of Mel
Brooks’s movie “High Anxiety”. The campus was known as The Great
Asylum for the Insane in the 19th century, and even includes a tower.

High Anxiety,
whenever…

Tokutek officially announced the TokuDB for MySQL v2.0 Storage Engine, v2.0 on April 16th, 2009. TokuDB uses Fractal Tree (TM) technology… to boost MySQL performance for users challenged with interactive querying in high volume, always-on applications. As a pure SW

Posted by Bradley C. Kuszmaul and David Wells

Executive Summary: A MySQL straight join can speed up a query that is very similar to TPC-H Q2 by a factor of 159 on MySQL.
Recently, we began looking at TPC-H performance…