What a Performance! MySQL 5.5 and InnoDB 1.1 running on Oracle Linux

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

perf_graph.jpg
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
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Get the latest updates on strategy, products, events, news, customers, partners and all things Oracle Linux! Connect with Oracle's Linux experts.

Stay Connected

Twitter


Facebook

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
5
8
9
10
11
12
13
15
16
17
18
19
20
22
23
24
25
26
27
29
30
31
     
Today