Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
October 23, 2010
MySQL Limitations Part 2: The Binary Log
This is the second in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1). In the [...]
October 20, 2010
MySQL Limitations Part 1: Single-Threaded Replication
I recently mentioned a few of the big “non-starter” limitations Postgres has overcome for specific use cases. I decided to [...]
October 4, 2010
Sharing an auto_increment value across multiple MySQL tables
The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar [...]
September 23, 2010
More on dangers of the caches
I wrote couple of weeks ago on dangers of bad cache design. Today I’ve been troubleshooting the production down case [...]
September 10, 2010
Cache Miss Storm
I worked on the problem recently which showed itself as rather low MySQL load (probably 5% CPU usage and close [...]
August 10, 2010
Why message queues and offline processing are so important
If you read Percona’s whitepaper on Goal-Driven Performance Optimization, you will notice that we define performance using the combination of [...]
July 24, 2010
Caching could be the last thing you want to do
I recently had a run-in with a very popular PHP ecommerce package which makes me want to voice a recurring [...]
July 15, 2010
Data mart or data warehouse?
This is part two in my six part series on business intelligence, with a focus on OLAP analysis. Part 1 [...]
July 13, 2010
Scaling: Consider both Size and Load
So lets imagine you have the server handling 100.000 user accounts. You can see the CPU,IO and Network usage is [...]
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 [...]