What a Performance! MySQL 5.5 and InnoDB 1.1 running on Oracle Linux
Posted
by zeynep.koch(at)oracle.com
on Oracle Blogs
See other posts from Oracle Blogs
or by zeynep.koch(at)oracle.com
Published on Wed, 09 Feb 2011 18:51:45 +0000
Indexed on
2011/02/09
23:30 UTC
Read the original article
Hit count: 1122
Filed under:
Error when finding categories...
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
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.
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.
By Mat Keep
© Oracle Blogs or respective owner
