Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
September 30, 2009
Admin notice: comments again broken
(This note should not go to PlanetMySQL, sorry if it goes). We again have problem with comments to blog posts. [...]
September 29, 2009
Quick comparison of MyISAM, Infobright, and MonetDB
Recently I was doing a little work for a client who has MyISAM tables with many columns (the same one [...]
September 28, 2009
How the number of columns affects performance
It is pretty understood the tables which have long rows tend to be slower than tables with short rows. I [...]
September 28, 2009
Why InnoDB index cardinality varies strangely
This is a very old draft, from early 2007 in fact. At that time I started to look into something [...]
September 25, 2009
InnoDB/XtraDB Training in New York City!
Our Santa Clara/San Francisco training went great – 100% of survey respondents said they would recommend the same course to [...]
September 24, 2009
Speaking at Highload.ru
This is a quick announcement to say that I’ll be speaking at HighLoad++ this year (October 12-14 in Moscow). I’ll [...]
September 20, 2009
Guidance for MySQL Optimizer Developers
I spend large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to [...]
September 19, 2009
Multi Column indexes vs Index Merge
The mistake I commonly see among MySQL users is how indexes are created. Quite commonly people just index individual columns [...]
September 18, 2009
Attempting to Quantify Fragmentation Effects
We often hear from customers and MySQL experts that fragmentation causes problems such as wasting disk space, increasing backup times, [...]
September 12, 2009
Cache Miss Rate as a function of Cache Size
I saw Mark Callaghan’s post, and his graph showing miss rate as a function of cache size for InnoDB running [...]
September 11, 2009
Sponsoring OpenSQL Camp 2009
We’re supporting the OpenSQL Camp, which will be held in Portland on November 14. One of my objectives for the [...]
August 17, 2009
Sorting a Terabyte in 197 seconds
Sorting a Terabyte in 197 seconds I just returned from The 21st ACM Symposium on Parallelism in Algorithms and Architectures [...]
August 6, 2009
Announcing TokuDB 2.1.0
Tokutek® announces the release the release of the TokuDB storage engine for MySQL®, version 2.1.0. This release offers the following [...]
August 3, 2009
Better Primary Keys, a Benefit to TokuDB’s Auto Increment Semantics
In our last post, Bradley described how auto increment works in TokuDB. In this post, I explain one of our [...]
July 29, 2009
Autoincrement Semantics
In this post I’m going to talk about how TokuDB’s implementation of auto increment works, and contrast it to the [...]
July 6, 2009
Fractal Trees May Be Useful for Making Energy-Efficient Databases
On April 9-10 the National Science Foundation hosted the Workshop on the Science of Power Management (SciPM 2009), where I [...]
June 24, 2009
Another look at improving TPC-H-like queries – Q17
Summary: An alternate approach, offered in response to our original post, provides excellent improvements for smaller databases, but clustered indexes [...]
June 23, 2009
A Second Rule of Thumb for Choosing Column Order in Indexes
A couple of weeks ago, Baron Schwartz wrote an interesting post describing a rule of thumb he sometimes uses to [...]
June 15, 2009
Improving TPC-H-like queries – Q17
Executive Summary: A query like TPC-H Query 17 can be sped up by large factors by using straight_joins and clustering [...]
June 11, 2009
MySQL 5.1 Grammar Changes to Support Clustering Indexes
This post is for storage engine developers that may be interested in implementing multiple clustering keys. After blogging about TokuDB’s [...]