# Oracle vs MySQL benchmark test

**URL:** <https://forums.percona.com/t/oracle-vs-mysql-benchmark-test/1149>\
**Category:** Other MySQL® Questions\
**Created:** [April 17, 2009, 5:14am UTC](https://forums.percona.com/t/oracle-vs-mysql-benchmark-test/1149 "2009-04-17T05:14:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![upsups](https://avatars.discourse-cdn.com/v4/letter/u/a587f6/32.png) [@upsups](https://forums.percona.com/u/upsups)\
**Post date:** [April 17, 2009, 5:14am UTC](https://forums.percona.com/t/oracle-vs-mysql-benchmark-test/1149/1 "2009-04-17T05:14:00Z")

</div>

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]](http://www.oracle.com/us/corporate/press/018144%5B/URL%5D)

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.

---

<div class="post-metadata">

**Author:** ![pkiula](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pkiula/32/808_2.png) [@pkiula](https://forums.percona.com/u/pkiula)\
**Post date:** [April 19, 2009, 2:44pm UTC](https://forums.percona.com/t/oracle-vs-mysql-benchmark-test/1149/2 "2009-04-19T14:44:50Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![upsups](https://avatars.discourse-cdn.com/v4/letter/u/a587f6/32.png) [@upsups](https://forums.percona.com/u/upsups)\
**Post date:** [April 19, 2009, 10:14pm UTC](https://forums.percona.com/t/oracle-vs-mysql-benchmark-test/1149/3 "2009-04-19T22:14:29Z")

</div>

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.