Benchmarks

The MySQL database consistently scores among the top for performance, throughput and scalability. So it's no surprise that MySQL is used for some of the most demanding, high volume, business-critical applications at companies like Associated Press, Cox Communications, Google, Lufthansa, MIT Lincoln Labs, NASA, Sabre Holdings, Yahoo and others. Companies have implemented large "scale out" web and data warehouse applications running MySQL on dozens, hundreds and even thousands of commodity Intel and Opteron servers saving millions of dollars in the process. MySQL scales to deal with billions of rows and terabytes of data making it suitable for a wide range of transactional and analytic applications.

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.

Read More »

MySQL/Sun set World Record SPECJ Benchmark

Two Sun Fire X4150 servers running MySQL, OpenSolaris, and the GlassFish application server posted the best Open Source result on the SPECjAppServer2004 benchmark. The results became official on 11/6/2008. The pair of Sun Fire X4150 servers, each equipped with one Intel Xeon CPU, delivered a world record Open Source result of 1197.10 SPECjAppServer2004 JOPS@Standard. The combination of MySQL, OpenSolaris, and GlassFish coupled with compact Sun Fire X4150 servers demonstrates the best price/performance ever recorded on the SPECjAppServer2004 benchmark.

The total cost of acquisition for Sun's solution is the lowest among all published SPECjAppServer2004 benchmark results. The MySQL/Sun solution has 53 times better cost than other competing solutions such as Dell and HP. Sun's MySQL-based solution has about the same performance of the Dell and HP offerings, but costs less than 2% to acquire with respect to Dell, and 5% with respect to the HP configuration.

For detailed test results, see the following links:

• Sun Fire X4150 Server - Benchmarks
• Sun Demonstrates Compelling Price Performance: Tom Daly's Weblog
• OpenSolaris SPECjAppServer Sun Fire X4150

MySQL 5.0 Helps Set World Record in Java Application Server Benchmark

A popular application server benchmark, featuring a complete open source software stack with MySQL 5.0 database, the Solaris 10 operating system, and Sun Java Systems Application Server 9.0 Platform Edition (Project GlassFish) has shattered the competition by offering up to 8.6 times lower cost of acquisition than the comparable solution, according to the SPEC benchmark test results.
Read More  »