The Nitro Storage Engine: Simple Steps to Extreme Performance

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.

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.