The Nitro Storage Engine: Simple Steps to Extreme Performance

Paul Whittington (NitroSecurity, Inc.)

Attendees will be introduced to NitroSecurity’s NitroEDB for MySQL (N4M) storage engine, and shown a few simple steps for migrating an existing MyISAM table to an Nitro table. In particular, this presentation will illustrate how to use N4M’s MySQL DDL extensions to transform a demonstration MyISAM table create statement into an N4M table create statement that uses several performance enhancing features of N4M. The N4M features illustrated will include index batching, time differentiated sub-fields, index SUM aggregates, index file sets, and fine grain memory management. MyISAM and N4M performance measurements will be compared for the demonstration table running on a commodity computer system. The presentation will conclude with a description of a production system that uses the demonstrated features, along with the newly released NitroEDB time partitioning feature, and its associated performance measurements.

Photo of Paul Whittington

Paul Whittington

NitroSecurity, Inc.

Paul Whittington heads up the Nitro for MySQL technical team at NitroSecurity. Whittington is a database and embedded systems engineer with over 28 years of experience. He holds a BS in Mechanical Engineering from the California State Polytechnic University in Pomona. Whittington served as an Advisory Engineer with Lockheed-Martin Idaho Technologies, a Senior Engineer with EG&G Idaho, Inc., a Software Engineer with Intelligent Instrumentation, Inc., and a Staff Engineer with IBM Corporation. Paul holds several design patents.

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 scordesse@oreilly.com

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@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

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.