Inserts at Drive Speed: Designing a Custom Storage Engine for Write-Mostly Applications

ISV/OEM, Storage Engine Development and Optimization
Location: Ballroom G Level: Intermediate

MySQL offers a variety of storage engines that can be matched to application requirements. Data can be integrated seamlessly between storage engines. When none of the existing engines look like a perfect match to your requirements, you can add your own. MySQL provides a SQL stack for your data. By leveraging the integration between storage engines, you are free to concentrate on just the design of key tables.

Writing a custom engine can seem intimidating and creating a generic engine can be. This storage engine provides fast, lock-free inserts and deletes into a read-only table with very low resource usage. We will discuss the problem addressed, why the approach was chosen, general 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.

Ben Haley


I spent the last 8 years building high-performance products for network monitoring. MySQL has been a key part of those products.

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.