How to Fulfil the Potential of InnoDB's Performance and Scalability

Average rating: ***..
(3.00, 8 ratings)

The InnoDB Plugin and its derivative XtraDB were added variable options/patches
for performance tuning, based on the discussions among InnoDB experts in the world.
The most of the options can optimize performance for multi-core and large memory servers,
RAID storage with many HDD, or much faster storage like SDD.

This session describes such new options and fixes based on ‘SHOW ENGINE INNODB STATUS’ outputs.
And you can see the real effects from the benchmark results.
So, you might be able to judge whether the builtin-InnoDB is enough or not for your systems,
or tune InnoDB Plugin and XtraDB correctly for your server and workload.

And, the tuning of the unusual processing (such as recovery from crushing) are also mentioned.

The next problem to be fixed or tunable in the future may be introduced, if I will have enough time remain.

Yasufumi Kinoshita

Percona Inc.

Yasufumi Kinoshita is Performance Engineer of Percona Inc., developed patches to improve InnoDB scalability and IO subsystems in these years.
He is main developer of XtraDB and XtraBackup.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

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

Download the O'Reilly MySQL Conference & Expo 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

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.