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).
The configurations in which MySQL has been tested are listed in the following table:
|Database + JPA Provider||Normalized Score|
100 - Best, 0 - Worst
1 - Best, 32 - Worst
|1||Hibernate with MySQL server||7.7||10 (out of 32)||0|
|2||EclipseLink with MySQL server||7.4||11 (out of 32)||0|
|3||OpenJPA with MySQL server||5.5||16 (out of 32)||29|
|4||DataNucleus with MySQL server||2.1||28 (out of 32)||5|
As shown above, MySQL was faster when used with Hibernate or EclipseLink as a JPA provider.
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:
- InnoDB was used in this benchmark (by default) by DataNucleus and OpenJPA.
- MyISAM was used in this benchmark (by default) by Hibernate and EclipseLink.
innodb_flush_log_at_trx_commitconfiguration option has been set to