Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
August 28, 2009
Innodb performance gotcha w Larger queries.
Couple of days ago I was looking for a way to improve update performance for the application and I was [...]
August 10, 2009
Sphinx at MySQL Meetup at San Francisco
I will be presenting at upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx [...]
August 6, 2009
Why you don’t want to shard.
Note: This blog post is part 1 of 4 on building our training workshop. The Percona training workshop will not [...]
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 [...]