MySQL Database Server

MySQL Performance Summary

The following charts show the performance of MySQL (in green) relatively to other JPA/DBMS combinations (in gray).

Position #1 on the X-Axis (the fastest) is about 100 times faster than position #32 (the slowest).
In the chart below the Y-Axis represents result score (maximum 100) in logarithmic scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB
In the chart below the Y-Axis represents result score (maximum 100) in linear scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB


The configurations in which MySQL has been tested are listed in the following table:

 Database + JPA ProviderNormalized Score
100 - Best,  0 - Worst
Final Position
1 - Best,  32 - Worst
Failed Tests
1Hibernate with MySQL server7.710  (out of 32)0
2EclipseLink with MySQL server7.411  (out of 32)0
3OpenJPA with MySQL server5.516  (out of 32)29
4DataNucleus with MySQL server2.128  (out of 32)5

As shown above, MySQL was faster when used with Hibernate or EclipseLink as a JPA provider.

About MySQL

MySQL is probably the most popular open source database today. The MySQL database was developed by MySQL AB and first released in 1995. It has been acquired by Sun Microsystems in 2008. Now MySQL is owned by Oracle Corporation.

MySQL is available under a dual license. It is free under the GPL license for in house and open source projects. A commercial license is required in other cases.

In this benchmark MySQL version 5.1.50 (which was released in 2010) has been tested.

The MySQL server can be used with two different database engines - MyISAM and InnoDB:

To avoid flush to the disk on every transaction by InnoDB (which affects the performance of insert/update/delete mainly in small transactions) the innodb_flush_log_at_trx_commit configuration option has been set to 0.