MySQL 5.5: Storage Engine Performance Benchmark for MyISAM and InnoDB
With the release of MySQL 5.5, InnoDB has become the default storage engine.
InnoDB is designed to handle transactional applications that require crash recovery, referential integrity, high levels of user concurrency and fast response times. The purpose of this whitepaper is to directly compare performance of the latest InnoDB 1.1 release included with MySQL 5.5 and MyISAM, using a benchmark that is commonly run to measure MySQL throughput.
The paper also discusses the most common use cases for both InnoDB and MyISAM, enabling readers to assess the best storage engine for their specific application requirements.