Oracle vs MySQL benchmark test

Hello,

With reference to Oracle benchmark test detailed below, we’ve done a relatively simpler test between MySQL (on InnoDB) and Oracle 11g (Enterprise Edition) using similar H/W configuration but with a simpler DB schema which consists of only a few tables and no additional alternate index. The test program was runs (in multiple threads) to insert and update records onto the DB continuously until a total of 100M records were created and then the total time taken recorded in msec. As a result, we found that Oracle was able to deliver a performance of 86K insertion/sec whilst MySQL was delivering 28K insertion/sec (which is only about 1/3 of Oracle figure) both under the same H/W and SAN storage configurations.

Wonder if anyone has any comments to this result and if this relatively big gap in performance a reasonable figure between MySQL and Oracle or would there be other suggestions for us to better tune the MySQL to make it performs a bit more better. Note that for test run with Oracle, we found that disk utilization reached upto more than 90% but only 60-70% for MySQL test.

Thanks very much in advance.

[URL]http://www.oracle.com/us/corporate/press/018144[/URL]

Oracle Database 11g Standard Edition One and HP ProLiant Deliver Highest Performance per Processor of any TPC-C Result ever Published
Redwood Shores, CA – March 30, 2009

News Facts
Today, Oracle announced a new world record TPC-C benchmark for a two-socket system with Oracle® Database 11g Standard Edition One running on Oracle Enterprise Linux, (1) demonstrating the superior enterprise-class performance, scalability and flexibility of Oracle Database for customers of all sizes.

Achieving 631,766 transactions per minute with a price/performance of $1.08/tpmC, Oracle Database 11g Standard Edition One running Oracle Enterprise Linux on an HP ProLiant DL370 G6 server equipped with two Intel® Xeon® x5570 quad-core 2.93 GHz processors, delivered the fastest result for a two-socket system as well as the highest transaction-per-minute-per-processor of any TPC-C result ever published. The storage subsystem consisted of HP StorageWorks MSA2324fc and MSA70 enclosures.

Dont know about Oracle but MySQL surely can do a lot better than 28K that you mention. Postgresql in 8.3 can do many multiple times over that number. Both are much lower in cost than an Oracle environment.

Hello pkiula,

Thanks for the comment.

Would there be any further advices in relation to the fine tuning of the MySQL environment/configuration such that a much better result as you mentioned can be delivered by MySQL. The MySQL version we used in the benchmark test was 5.1.30 and both DB tests were run under a RHEL 5.2 (64 bits) environment.