Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 24, 2009
Maatkit Now Supports Memcached
Have you ever wondered how optimized your Memcached installation is? There is a common misconception that one doesn’t have to [...]
July 6, 2009
Just do the math!
One of the most typical reasons for performance and scalability problems I encounter is simply failing to do the math. [...]
April 19, 2009
Talking MySQL to Sphinx
In the recently released Sphinx version 0.9.9-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language [...]
March 17, 2009
Converting Character Sets
The web is going the way of utf8. Drizzle has chosen it as the default character set, most back-ends to [...]
March 5, 2009
What does Using filesort mean in MySQL?
If you were interviewing to work at Percona, and I asked you “what does Using filesort mean in EXPLAIN,” what [...]
March 2, 2009
Understanding Performance Optimization Terminology
There are few terms you need to have a good understanding if you’re working with high volume systems. I commonly [...]
January 23, 2009
Optimizing repeated subexpressions in MySQL
How smart is the MySQL optimizer? If it sees an expression repeated many times, does it realize they’re all the [...]
January 19, 2009
Profiling MySQL stored routines
These days I’m working with a customer who has an application based entirely on stored routines on MySQL side. Even [...]
December 22, 2008
High-Performance Click Analysis with MySQL
We have a lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, [...]
December 22, 2008
Goal driven performance optimization
When your goal is to optimize application performance it is very important to understand what goal do you really have. [...]
November 28, 2008
Computing 95 percentile in MySQL
When doing performance analyzes you often would want to see 95 percentile, 99 percentile and similar values. The “average” is [...]
November 26, 2008
Memcached Status
There are all sorts of different interfaces to memcached, but you don’t need any of them to make requests from [...]
November 24, 2008
How Percona does a MySQL Performance Audit
Our customers or prospective customers often ask us how we do a performance audit (it’s our most popular service). I [...]
November 8, 2008
Drilling down to the source of the problem
I had an interesting tuning case few days ago. The system serving high traffic using Innodb tables would be stalling [...]
November 5, 2008
Election night
Today was epoch day in American history. Maybe even most important day this year, but it’s not what I’d like [...]
September 24, 2008
Four ways to optimize paginated displays
A paginated display is one of the top optimization scenarios we see in the real world. Search results pages, leaderboards, [...]
September 20, 2008
A common problem when optimizing COUNT()
When optimizing queries for customers, the first thing I do with a slow query is figure out what it’s trying [...]
August 18, 2008
Worse than DDOS
Today I worked on rather interesting customer problem. Site was subject what was considered DDOS and solution was implemented to [...]
August 9, 2008
Picking datatype for STATUS fields
Quite commonly in applications, you would need to use some kind of “status” field – the status of an order [...]
August 4, 2008
To find the bottleneck, stop guessing and start measuring
We recently examined a customer’s system to try to speed up an ETL (Extraction, Transformation and Loading) process for a [...]