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.
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
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.