First off, let me wish you all a Happy 2009, and my apologies for
being a bit slack with blogging in the last two months of 2008.
It’s been a bunch of busy weeks, but I’m fully expecting to
remedy that in this year.
Second, let me welcome you to this series on refactoring MySQL
applications. I will cover best practices and useful tips, as
well as show working examples of potential loopholes and
solutions.
So, you are a DBA or a developer, and you’re faced with a
problem. Your years-old application (perhaps you inherited it
from a former co-worker) is now starting to keel over, and your
choice of responses is limited.
Let’s start by saying that there are other ways to reach
performance, but in some cases refactoring may be the only way
that is possible to pursue, for one reason or another. Let’s take
the refactoring way, focusing on SQL rather than applications, as
there’s a lot that can be done on this side. …
[Read more]