Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
November 16, 2009
“Shard early, shard often”
I wrote a post a while back that said why you don’t want to shard. In that post that I [...]
November 15, 2009
NDB API examples, the trivia to make ndbapi_scan works!
When I did NDB Cluster engagements, it happened a few time that I had to cover the NDB API. Once, [...]
November 12, 2009
Would you like to ask a question about PBXT?
In the next week, I’ll be interviewing Paul McCullagh, the architect behind the PBXT storage engine. If you have any [...]
September 28, 2009
How the number of columns affects performance
It is pretty understood the tables which have long rows tend to be slower than tables with short rows. I [...]
September 20, 2009
Guidance for MySQL Optimizer Developers
I spend large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to [...]
September 12, 2009
3 ways MySQL uses indexes
I often see people confuse different ways MySQL can use indexing, getting wrong ideas on what query performance they should [...]
September 10, 2009
What to do with MySQL Full Text Search while migrating to Innodb ?
It is rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason [...]
August 29, 2009
Give me 8 hours, and I’ll help you build a better application
I have run into a number of cases recently that all had a similar look and feel. In most of [...]
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, [...]