Comparison between Oracle and MySQL

The authoritative eWeek test shows that MySQL 4.0.1 is comparable to Oracle 9i.

EWEEK Labs/PC Labs can be said to be the leader in Benchmark Testing. As early as October 1993, their sister Magazine PC Magazine did the same test. This cooperation with PC Magazine has tested the performance of five types of databases on the Java application server. The results show that the performance of MySQL's latest version 4.0.1 is comparable to that of Oracle 9i, of course, Microsoft's SQL Server 2000 is low. :-)
The five databases tested are: IBM DB2 7.2 FixPack 5, Microsoft SQL Server 2000 Enterprise Edition SP2, MySQL AB MySQL 4.0.1 Max, oracle Oracle9i Enterprise 9.0.1.1.1 and Sybase ASE (Adaptive Server Enterprise) 12.5.0.1.

Testing compatibility is also a major purpose of benchmarking. All databases are tested under the same hardware conditions:
HP NetServer LT 6000r comes with four 700 MHz Xeon CPUs, 2 GB memory and 24 10000 GB Ultra3 SCSI disks with 9.1 rpm, and the operating system is Windows 2000 Advanced Server SP2.

The tested application is a Web-based bookstore application called Nile. Nile uses the Empirix testing Suite 6.0 to load 50 to 10000 concurrent users.

The application server used in the test is WebLogic 6.1 SP1 of BEA, and Nile applications are compiled using JSP.

Each test runs 50 thousand orders per hour, with 0.15 million to 0.2 million records. The best scalability we get is that we have two 6-channel HP NetServer LT 6000r (4 GB memory, A Gigabit Nic) runs six WebLogic routines on the server. The allocation of HTTP traffic balance to these six cases.

The overall test results show that Oracle9i and MySQL have the best performance and scalability, but 9i is only slightly better than MySQL, ASE, DB2, when Oracle9i and MySQL reach 550 concurrent users, the performance of ASE is reduced to 500 pages per second, which is 100 fewer than 9i and MySQL, under high load conditions, DB2's performance is also dropping sharply, with only 200 pages per second.

Due to JDBC driver problems, SQL Server can only reach 200 pages per second throughout the test.

Driver, memory optimization, and database design problems are the main factors affecting performance. After manual fine-tuning, the performance will be twice as bad as the performance without optimization.

Oracle and MySQL drivers have complete JDBC features and stability (MySQL employees use JDBC drivers written by Mark donews because they do not have their own JDBC drivers ).

1 2 3 Next Page