Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 12, 2010
Intro to OLAP
This is the first of a series of posts about business intelligence tools, particularly OLAP (or online analytical processing) tools [...]
July 5, 2010
mk-query-digest, query comments and the query cache
I very much like the fact that MySQL allows you to embed comments into SQL statements. These comments are extremely [...]
June 15, 2010
What does Handler_read_rnd mean?
MySQL’s SHOW STATUS command has two counters that are often confusing and result in “what does that mean?” questions: Handler_read_rnd [...]
June 15, 2010
EXPLAIN EXTENDED shows what MySQL optimizer does to your query
While many people are familiar with the MySQL EXPLAIN command, fewer people are familiar with “explain extended” which was added [...]
June 7, 2010
Performance Optimization and Six Sigma
You might be familiar with Six Sigma business management strategy which is employed by variety of the companies in relationship [...]
June 2, 2010
Color code your performance numbers
When analyzing how good or bad response time is it is not handy to look at the averages, min or [...]
May 31, 2010
On Good Instrumentation
In so many cases troubleshooting applications I keep thinking how much more efficient things could be going if only there [...]
May 19, 2010
A workaround for the performance problems of TEMPTABLE views
MySQL supports two different algorithms for views: the MERGE algorithm and the TEMPTABLE algorithm. These two algorithms differ greatly. A [...]
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 [...]