Posted on 2 Comments

Optimization tutorials at MySQL UC

At the MySQL Users Conference 2006, we have a tutorial day on Monday April 24th. These are optional extras to the general conference pass, so you have to specifically add these when you register. The most popular sessions and tutorials are always the performance tuning items. No great surprise there…

Last year I just did a talk in the main conference. But I usually do tutorials at other conferences, so for this year’s UC I came up with a new topic:
Optimizing MySQL Applications Using the Pluggable Storage Engine Architecture
Yea, very buzzword compliant – marketing loved it 😉
The point is this… MySQL has multiple storage engines: MyISAM, InnoDB, NDB Cluster, ARCHIVE, BLACKHOLE, FEDERATED, CSV. People often ask me a generic “which one is best?” and that kinda indicates that they don’t yet see the real benefits of this architecture.

The type of data and access pattern defines which engine or engines are suitable. And even a single application can have different components that can benefit to using different engines! MySQL can handle this, as it allows you to choose an engine on a per-table basis. Sounds complicated? It’s not that bad, but the tutorial will clarify it all!
And of course, once you use an engine, you’ll want to use and tune it for optimal performance.
Got your interest?
It’d be cool if this first tutorial is the first to sell out this year…

In the afternoon we also have MySQL Performance Optimization by Peter Zaitsev (head of the MySQL high performance group) and Tobias Asplund (MySQL trainer/consultant).

Going to both of these is probably going to give you significant overlap, so perhaps it’s best to pick one of the above and then one of the 8 other items! See the list of all available tutorials.
Remember, early registration closes March 6th. During early reg you actually get the second tute free when you sign up for one. That’s a pretty good deal…

Posted on 2 Comments

2 thoughts on “Optimization tutorials at MySQL UC

  1. I have registered for the conference but signed up for a different tutorial. How do I change what I signed up for? This tutorial on storage engines would help clear some things up for me.

  2. Hehe – no worries.
    See http://www.mysqluc.com/pub/w/45/register.html
    Near the bottom of that page you will find the email address (confreg at O’Reilly) to talk with.

Comments are closed.