InnoDB: Performance and Scalability Features

Data: Relational
Location: C121/122
Average rating: *....
(1.33, 6 ratings)

InnoDB is the default storage engine for MySQL as of MySQL 5.5. It has always been highly efficient, and includes many unique architectural elements to assure high performance and scalability.

The InnoDB storage engine in MySQL 5.5 includes many new features that take better advantage of recent advances in operating systems and hardware platforms, and permit users to better control the use of some InnoDB internal subsystems to achieve the best performance.

Inaam Rana


Inaam Rana is a core member of the InnoDB development team at MySQL. He joined the InnoDB team in April 2007. His area of focus has been performance and scalability of the InnoDB storage engine. He has been mostly working on the buffer cache layer, low level concurrency and OS layer. Inaam has had a chance to contribute to the most of the scalability features that were included in the InnoDB plugin. In his previous work experience he had been involved in development of IBM’s DB2 LUW and PostgreSQL database engines. Inaam currently lives in Toronto, Canada.

Photo of Calvin Sun

Calvin Sun


Calvin Sun is the senior engineering manager at Twitter, managing the MySQL development. Prior to that, he was managing the InnoDB team at Oracle. Calvin was a development manager at MySQL from 2006 to 2008, managing MySQL storage engines and 3rd party storage engine vendors relationships. He has over 15+ years of database development experience, mostly on various storage engines.

Comments on this page are now closed.


Picture of Calvin Sun
Calvin Sun
07/26/2011 7:02pm PDT

I apologize for the late arrival. I got the start time wrong. For most of performance features, they work out of the box. We do provide details of those features on various articles on Thanks for attending!

Mark Russo
07/25/2011 10:02am PDT

Speaker arrived over 15 minutes late. The slide deck lists many internal things that were changed in InnoDB, but doesn’t explain anything about how to utilize the changes. Okay, scalability has been improved. How about illustrating with a case study and providing advice on how to build a high performance system with the newer versions of MySQL?