Do you have a query you never dared to touch? Do you know it’s bad, but it’s needed? Does it fit your screen? Does it really have to be that expensive? Do you want to do something about it? During the next Percona webinar on February 27, I will present some techniques that can be [...]
Percona MySQL Webinar: Really Large Queries: Advanced Optimization Techniques, Feb. 27
February 18, 2013 By 2 Comments
What’s required to tune MySQL?
July 27, 2011 By 4 Comments
I got a serendipitous call (thanks!) yesterday asking what would be needed to tune[1] a database for better performance. It is a question that I hear often, but I never thought about answering it in public. Here’s a consolidated version of what I explained during our conversation.
3 Common Rails + MySQL Mistakes
February 14, 2011 By Leave a Comment
This is a cross-posting of an article we wrote for Engine Yard: Rails makes database interaction so simple that it’s easy to forget that the database isn’t always happy with what Rails does to it. Here are three leading mistakes that hurt many Rails applications. » Read the rest at Engine Yard’s blog. While you’re [...]
3 ways MySQL uses indexes
September 12, 2009 By 28 Comments
I often see people confuse different ways MySQL can use indexing, getting wrong ideas on what query performance they should expect. There are 3 main ways how MySQL can use the indexes for query execution, which are not mutually exclusive, in fact some queries will use indexes for all 3 purposes listed here.
Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
The problem of MySQL Replication unable to catch up is quite common in MySQL world and in fact I already wrote about it. There are many aspects of managing mysql replication lag such as using proper hardware and configuring it properly. In this post I will just look at couple of query design mistakes which [...]
