MySQL Users Conference 2006 “MySQL is at the heart of revolutionary changes in computer history.“—Tim O'Reilly
 Co-presented by O'Reilly Media, Inc. and MySQL AB
 Conference Coverage


Optimizing MySQL Applications Using the Pluggable Storage Engine Architecture

Arjen Lentz, Community Relations Manager, MySQL AB

Track: General
Date: Monday, April 24
Time: 8:30am - 12:00pm
Location: Ballroom E

In this tutorial, Lentz takes an in-depth look at MySQL's "Pluggable Storage Engine" architecture. Understanding the features and trade-offs in each engine allows developers to optimize their applications by making appropriate choices and tuning the MySQL server appropriately for their needs.

For example, logging of page clicks on a web site places completely different requirements on a database from, say, tracking customers and sales. Functionally, either can be done using generic solutions. But by utilizing specific features available in specialised storage engines, extraordinary performance improvements can be attained.

This becomes particularly relevant when there are specific speed and scalability requirements for an application. A general purpose storage system would simply not do.

In MySQL, the storage engine can be selected on a per-table basis. This means that different engines can be used from within a single application, as appropriate for the application's needs. In many cases, the application need not even be aware which engine is used.

In this tutorial, the different available storage engines will be compared. Also, the fundamentals of adding new storage engines will be discussed.

Diamond Sponsor

Business Objects
Hewlett Packard

Platinum Sponsors

Four J's Development Tools, Inc
GoldenGate Software, Inc.

Gold Sponsors

Actuate Corporation
Data Direct Technologies
Dell Inc.
Dolphin Interconnect Solutions
Embarcadero Technologies
EMC Centera
Lumen Software
Novell, Inc.
Rackspace Managed Hosting
Red Hat
Sun Microsystems
The SCO Group
Zmanda, Inc.

Media Sponsors

Conference Guru
Database Trends and Applications
DevtownStation News
IPTV Industry
Linux Journal
Methods and Tools newsletter
Sys Admin magazine
The ServerSide
The Women's Technology Cluster
Web Host Industry Review
WiMAX Industry

In-Kind Sponsors

Griffin Technology

Sponsor Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact us at

Download the MySQL Users Conference Sponsor/Exhibitor Prospectus

Conference News

To stay abreast of conference news and to receive email notification when registration opens, please sign up here.

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Copyright MySQL AB and O'Reilly Media, Inc.
MySQL O'Reilly