by Peter Zaitsev | Jun 19, 2009 | Percona Events
I will co-present in webinar on Performance Challenges and Solutions for IO Bound Workloads in MySQL. My part of the presentation will be speaking about why switching from CPU bound workload to IO bound is such an important event, how to prepare to it as well as how...
by Baron Schwartz | Jun 5, 2009 | Insight for DBAs
I wanted to share a little rule of thumb I sometimes use to choosing column order in indexes. This is not specific to MySQL, it’s generally applicable to any database server with b-tree indexes. And there are a bunch of subtleties, but I will also ignore those...
by Baron Schwartz | Feb 12, 2009 | Insight for DBAs
I vaguely recall a couple of blog posts recently asking something like “what’s the formula to compute mysqld’s worst-case maximum memory usage?” Various formulas are in wide use, but none of them is fully correct. Here’s why: you...
by Aurimas Mikalauskas | Jan 19, 2009 | Insight for Developers
These days I’m working with a customer who has an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s going to be a piece of cake. In the end – it was, but...
by Peter Zaitsev | Dec 22, 2008 | Insight for Developers
When your goal is to optimize application performance it is very important to understand what goal do you really have. If you do not have a good understanding of the goal your performance optimization effort may well still bring its results but you may waste a lot of...
by Baron Schwartz | Nov 24, 2008 | Insight for Developers
Our customers or prospective customers often ask us how we do a performance audit (it’s our most popular service). I thought I should write a blog post that will both answer their question, so I can just reply “read all about it at this URL” and...
by Baron Schwartz | Nov 21, 2008 | Insight for DBAs
Peter wrote a post a while ago about choosing a good InnoDB log file size. Not to pick on Peter, but the post actually kind of talks about a lot of things and then doesn’t tell you how to choose a good log file size! So I thought I’d clarify it a little....
by Yasufumi Kinoshita | Nov 13, 2008 | Benchmarks, Percona Software
Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”. — limit of “amount” — As you know, buffer...
by Ryan Lowe | Oct 21, 2008 | Uncategorized
We have written before about the importance of using numeric types as keys, but maybe you’ve inherited a schema that you can’t change or have chosen string types as keys for a specific reason. Either way, the character sets used on joined columns can have...
by Baron Schwartz | Sep 20, 2008 | Insight for Developers
When optimizing queries for customers, the first thing I do with a slow query is figure out what it’s trying to do. You can’t fully optimize a query unless you know how to consider alternative ways to write it, and you can’t do that unless you know...
by Vadim Tkachenko | Sep 9, 2008 | Benchmarks, Percona Software
We are going to show the effects of the new patches applied to Percona HighPerf release. As you see from the following graphs, there is significant difference to normal version when the data bigger than buffer pool (right graph shows CPU usage) The workload emulates...
by Baron Schwartz | Aug 18, 2008 | Insight for DBAs
There are quite a few “tuning primers” and “my.cnf generators” and “sample my.cnf files” online. The ultimate tool for generating an optimal my.cnf is not a tool. It’s a human with many years of experience, deep knowledge of...
by Baron Schwartz | Aug 4, 2008 | Insight for Developers
We recently examined a customer’s system to try to speed up an ETL (Extraction, Transformation and Loading) process for a big data set into a sort of datamart or DW. What we typically do is ask customers to run the process in question, and then examine...
by Peter Zaitsev | May 16, 2006 | Insight for DBAs
I’ve now added one more presentation to MySQL Performance Presentations page. This presentation is from MySQL Users Conference 2006 which was presented by Vadim but which we prepared together. Hope you enjoy it. Get it here
