Schedule: Storage Engine Development and Optimization sessions

Location: Ballroom B Level: Intermediate
Roland Bouman (XCDSQL Solutions / Strukton Rail), Sergei Golubchik (MariaDB)
Average rating: *****
(5.00, 1 rating)
The MySQL plugin API is a generic extension point for the MySQL (>=5.1) server. It allows users to add new features like storage engines and information schema tables, and to extend existing features such as FULLTEXT search. In this tutorial, you will learn how to write your own plugins from one of the designers of the plugin API. Basic C/C++ programming skills are recommended but not required. Read more.
Location: Ballroom H Level: Intermediate
Sheeri K. Cabral (Mozilla Foundation), Patrick Galbraith (Hewlett Packard)
Average rating: ***..
(3.29, 7 ratings)
You don't have to read source code -- understanding how MySQL works can be achieved through the system data. Learn a wide range of topics in this 3-hour tutorial, and leave armed with tons of knowledge about how MySQL 5.0, 5.1 and 6.0 work. You will take home a healthy understanding of performance tuning, storage engines, replication and many tips and tricks to help you be a better DBA. Read more.
Location: Ballroom D Level: Intermediate
Peter Volk (DDEngine)
Average rating: ****.
(4.00, 3 ratings)
With the increase complexity of software architecture and database design the amount of data stored in databases systems grows rapidly. Additionally, data security and international regulatory laws require that data changes are audited and restorable to any point of time. The revision engine implements automated auditing of data transparently as a storage engine. Read more.
Location: Ballroom C Level: Expert
Philip Stoev (Sun Microsystems)
Average rating: ****.
(4.00, 3 ratings)
This session will present the Random Query Generator, a new tool for database workload generation for the purpose of stress testing. Read more.
Location: Ballroom D Level: Expert
Matthew Yonkovit (MySQL), Yves Trudeau (Percona)
Average rating: ***..
(3.67, 3 ratings)
The InnoDB storage engine has been modified to use memcached as a level 2 cache, the InnoDB buffer pool being the level 1. Important reduction of the disk load and performance boost has been observed. This opens a new way of scaling out MySQL. Read more.
Location: Ballroom E Level: Novice
Kevin Lewis (Sun Microsystems), Ann Harrison
Average rating: **...
(2.50, 2 ratings)
The Falcon Storage Engine is designed to take advantage of multi-core computers. It is reaching GA at a time when computer performance is being increased mostly by adding more cores. Falcon's unique characteristics will be explained and contrasted with InnoDB and other MySQL storage engines. Read more.
Location: Ballroom B Level: Intermediate
Paul McCullagh (PrimeBase Technologies GmbH)
Average rating: ****.
(4.00, 1 rating)
What are the challenges facing storage engines today and tomorrow? Solid state storage, 64 cores and beyond and cloud computing environments are all areas in which a storage engine must prove itself now, to be equipped for the future. This session will discuss the design of the PBXT transactional storage engine, and the ideas and solutions, planned and implemented to meet these challenges. Read more.
Location: Ballroom C Level: Intermediate
Beat Vontobel (MeteoNews AG)
Average rating: ***..
(3.00, 3 ratings)
Experienced SQL developers know how to solve a class of quite different problems efficiently with the help of an auxiliary sequence table: We'll learn from them with easy to understand hands-on examples -- and meet the SeqEngine, a pluggable storage engine for MySQL 5.1 that helps us to apply the expert's tricks even more efficiently. Read more.
Location: Ballroom B Level: Intermediate
Kazuho Oku (DeNA)
Average rating: ***..
(3.50, 4 ratings)
Q4M ( is a high-performance message queue that works as a pluggable storage engine of MySQL, used by Mixi (Japan's largest SNS provider) and Cybozu Labs (for running Pathtraq, one of the nation's largest web access stats service), etc. The presentation will cover from the design principles of Q4M, to how it is used to modularize, stabilize, and extend the web services. Read more.
Location: Ballroom B Level: Intermediate
Michael Widenius (Monty Program Ab)
Average rating: ***..
(3.25, 4 ratings)
The talk will describe the goals and design of Maria, the new transactional storage engine for MySQL. It will cover the goals of Maria Storage Engine, overall design, on-disk data formats, Multi-Version Concurrency Control in Maria, BLOB handling, row locking and lock escalation, roadmap (current and future). Read more.
Location: Ballroom C Level: Expert
Mattias Jonsson (Sun Microsystems), Mikael Ronstrom (MySQL)
Average rating: ***..
(3.75, 4 ratings)
Insights from the developers behind MySQL Partitioning. How is partitioning implemented, how does it work in the server and with the storage engines? What solutions can it be a part of and what problems does it introduce? We present a new partitioning type: Column list, range partitioning on any column type. And give the status of the current development. Read more.
Location: Ballroom B Level: Novice
Moshe Shadmon (ScaleDB)
ScaleDB storage engine delivers high performance transaction processing capability with row level locking and multi-node concurrency control. It enhances performance through innovative indexing technology and delivers low cost computing with a Shared Disk architecture. When applications demand more computing power, additional servers are added to the cluster to scale the system capacity. Read more.
Location: Ballroom C Level: Intermediate
Ben Handy (Google), Justin Tolmer (Google)
Average rating: *****
(5.00, 1 rating)
We are working on improving the performance and reliability of MySQL and InnoDB. We will describe each of the patches we have released, and how they are useful. Read more.
Location: Ballroom E Level: Intermediate
Heikki Tuuri (Innobase / Oracle Corp.), Calvin Sun (Twitter)
Average rating: **...
(2.75, 4 ratings)
This presentation describes InnoDB on-disk file formats, the new file format management, as well as InnoDB source code structure. Read more.
Location: Ballroom G Level: Intermediate
Ben Haley (CA-NetQoS)
Writing a custom engine can seem intimidating and creating a generic engine can be. This presentation will show how to refine the requirements to a manageable subset. We will discuss the problem addressed, the approach chosen, storage engine design and API required to implement the design. We will talk about lessons learned implementing the storage engine to improve flexibility and performance. Read more.
Location: Ballroom A Level: Expert
Stewart Smith (Percona)
Average rating: ***..
(3.00, 2 ratings)
How does the database server use memory? Where? What are the scaling implications of how we allocate, use and free memory in the database server? Can we scale to many CPU cores effectively? Do alternate malloc libraries really help? Why? What does MySQL do? What does Drizzle do (and what have we changed?). These questions (and more) will be answered in this session. Read more.
Location: Ballroom H Level: Intermediate
Vadim Tkachenko (Percona Inc), Ewen Fortune (Percona)
InnoDB is well-known and popular, but naturally there's room for improvement. There are many hard-coded constants – what happens if we turn them into command-line parameters? InnoDB is also incredibly complex, with a lot going on under the covers. What algorithms can we change to make InnoDB faster and more scalable, especially on modern hardware? Read more.
Location: Ballroom B Level: Intermediate
Barry Leslie (PrimeBase Technologies)
Average rating: ***..
(3.00, 2 ratings)
This talk will be on making use of the new BLOB Streaming: 'C' and PHP APIs to enable the efficient storage and retrieval of BLOB data from any table regardless of the engine behind it. Read more.
Location: Ballroom C Level: Intermediate
Kentoku SHIBA (WildGrowth)
Average rating: **...
(2.00, 1 rating)
The Spider Storage Engine creates table-links from local databases to remote databases. To supports XA transaction and table partitioning itself, the Spider also created for the database shardings. Spider Storage Engine is being offered to the public by GPL. Read more.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

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

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.