Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
August 1, 2008
How adding another table to JOIN can improve performance ?
JOINs are expensive and it most typical the fewer tables (for the same database) you join the better performance you [...]
July 20, 2008
Sphinx 0.9.8 is released just in time for OSCON 2008
As you probably already seen in a post by Baron, Sphinx Release 0.9.8 is finally out, just in time for [...]
July 20, 2008
Missing Data – rows used to generate result set
As Baron writes it is not the number of rows returned by the query but number of rows accessed by [...]
July 3, 2008
How to load large files safely into InnoDB with LOAD DATA INFILE
Recently I had a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal [...]
June 26, 2008
Web Site Optimization: FrontEnd and BackEnd
I spent Monday and Tuesday this week on Velocity Conference It was quite interesting event worth attending and it was [...]
June 17, 2008
Lighttpd as reverse proxy
We often recommend to set lighttpd in front of apache to handle http requests (more about https://www.percona.com/blog/speedup-your-lamp-stack-with-lighttpd/ ) , redirect dynamic [...]
May 20, 2008
Apache PHP MySQL and Runaway Scripts
Sometimes due to programming error or due to very complex query you can get your PHP script running too long, [...]
April 28, 2008
The MySQL optimizer, the OS cache, and sequential versus random I/O
In my post on estimating query completion time, I wrote about how I measured the performance on a join between [...]
April 23, 2008
Efficient Boolean value storage for Innodb Tables
Sometimes you have the task of storing multiple of boolean values (yes/now or something similar) in the table and if [...]