Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
May 17, 2010
Joining on range? Wrong!
The problem I am going to describe is likely to be around since the very beginning of MySQL, however unless [...]
May 10, 2010
Two Types of MySQL Users
In comments to my previous post I got number number of comments saying if MySQL would not have multiple storage [...]
May 5, 2010
Checking for a live database connection considered harmful
It is very common for me to look at a customer’s database and notice a lot of overhead from checking [...]
April 24, 2010
How fast is FLUSH TABLES WITH READ LOCK?
A week or so ago at the MySQL conference, I visited one of the backup vendors in the Expo Hall. [...]
March 30, 2010
Can we get faster expression handling in MySQL
Andrew from Sphinx continues to work on improving SQL (or SphinxQL) support and now he published benchmarks comparing arithmetic expression [...]
January 21, 2010
When Should You Store SQL Serialized Data in the Database?
A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing [...]
January 10, 2010
Active Cache for MySQL
One of the problems I have with Memcache is this cache is passive, this means it only stores cached data. [...]
January 9, 2010
Getting around optimizer limitations with an IN() list
There was a discussion on LinkedIn one month ago that caught my eye: Database search by “within x number of [...]
December 15, 2009
What do we optimize with mk-query-digest ?
When we’re looking at mk-query-digest report we typically look at the Queries causing the most impact (sum of the query [...]
December 9, 2009
Why delayed flushing can result in less work
I can think of at least two major reasons why systems delay flushing changes to durable storage: 1. So they [...]
December 4, 2009
Sphinx 0.9.9 is finally here.
Sphinx 0.9.9 is finally released to General Availability. The previous version 0.9.9-rc2 was released back in April so there was [...]
November 20, 2009
Paul McCullagh answers your questions about PBXT
Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as [...]
November 16, 2009
“Shard early, shard often”
I wrote a post a while back that said why you don’t want to shard. In that post that I [...]
November 15, 2009
NDB API examples, the trivia to make ndbapi_scan works!
When I did NDB Cluster engagements, it happened a few time that I had to cover the NDB API. Once, [...]
November 12, 2009
Would you like to ask a question about PBXT?
In the next week, I’ll be interviewing Paul McCullagh, the architect behind the PBXT storage engine. If you have any [...]
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 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 12, 2009
3 ways MySQL uses indexes
I often see people confuse different ways MySQL can use indexing, getting wrong ideas on what query performance they should [...]
September 10, 2009
What to do with MySQL Full Text Search while migrating to Innodb ?
It is rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason [...]
August 29, 2009
Give me 8 hours, and I’ll help you build a better application
I have run into a number of cases recently that all had a similar look and feel. In most of [...]