The MySQL performance team in Oracle has recently completed a series of benchmarks comparing Read / Write and Read-Only performance of MySQL 5.5 with the InnoDB and MyISAM storage engines.
Compared to MyISAM, InnoDB delivered 35x higher throughput on the Read / Write test and 5x higher throughput on the Read-Only test, with 90% scalability across 36 CPU cores.
A full analysis of results and MySQL configuration parameters are documented in a new whitepaper (http://www.mysql.com/why-mysql/white-papers/mysql_5.5_perf_myisam_innodb.php)
In addition to the benchmark, the new whitepaper (http://www.mysql.com/why-mysql/white-papers/mysql_5.5_perf_myisam_innodb.php), also includes:
- A discussion of the use-cases for each storage engine
- Best practices for users [Read more...]