What a Performance! MySQL 5.5 and InnoDB 1.1 running on Oracle Linux
By Zeynep Koch-Oracle on Feb 09, 2011
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
In addition to the benchmark, the new whitepaper, also includes:
- A discussion of the use-cases for each storage engine
- Best practices for users considering the migration of existing applications from MyISAM to InnoDB
- A summary of the performance and scalability enhancements introduced with MySQL 5.5 and InnoDB 1.1.
The benchmark itself was based on Sysbench, running on AMD Opteron "Magny-Cours" processors, and Oracle Linux with the Unbreakable Enterprise Kernel
You can learn more about MySQL 5.5 and InnoDB 1.1 from here and download it from here to test whether you witness performance gains in your real-world applications.