[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
[eclipselink-users] Database performance problem
|
Hi All,
actually Ive 2 problems. But first the main issue -> Database performance:
we are using Eclipselink(Javax.persistens 2.0.0, Eclipselink 2.0.2) and
MySQL (local 5.0.5, cluster 7.1.5) for built-up a back-end. At the
moment we using just one server bat later there are two(or more) server
which connect to one MySQL Cluster. That was and still is our architecture.
We are setting up a running Eclipselink environment whit a local MySQL
Database and it works fine. Last week we started to run same performance
test against the database.
This test was very simple: Write Log-Entities over Eclipselink in the
database.
At the beginning the inserts/s was about 200 and 600 but then the
inserts/s decreased to 0. We have tested on a local MySQL database and a
MySQL Cluster but the results are almost the same.
Ive attached a graph (inserts/s over time) of all the tests for getting
a better overview. The tests was not at the same time! Ive tried to
disable the cache in the persistense.xml and delete all Log-Entities
from the cache after each insert. The result was more or less the same
-> going down to 0 inserts/s. The biggest amount of entities in the
database was about 500000. The database was clean for each test. I think
that is not that big for a database. The system performance was "ok".
The CPU load about 70%-85% and the memory increased up to 3 GB. That was
the reason why I configures the NO CACHE.
Has anyone a hint what I can configure to solve the problem or getting a
better performance..?
persistemce.xml:
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0"
xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="database">
<class>de.service.logEntity</class>
....
<properties>
<!-- Embedded MySQL Login -->
<property name="eclipselink.target-database" value="MYSQL"/>
<property name="javax.persistence.jdbc.driver"
value="com.mysql.jdbc.Driver"/>
<property name="eclipselink.jdbc.read-connections.min"
value="10"/>
<property name="eclipselink.jdbc.write-connections.min"
value="10"/>
<property name="eclipselink.jdbc.batch-writing" value="JDBC"/>
<property name="javax.persistence.jdbc.password" value="root"/>
<property name="javax.persistence.jdbc.user" value="root"/>
<property name="javax.persistence.jdbc.url"
value="jdbc:mysql://10.0.3.11:3306/database"/>
<!-- Database Schema Creation -->
<property name="eclipselink.ddl-generation" value="none"/>
<property name="eclipselink.ddl-generation.output-mode"
value="both"/>
<shared-cache-mode>NONE</shared-cache-mode>
<!-- Logging Settings -->
<property name="eclipselink.logging.level" value="INFO" />
<property name="eclipselink.logging.thread" value="false" />
<property name="eclipselink.logging.session" value="true" />
<property name="eclipselink.logging.exceptions" value="true" />
<property name="eclipselink.logging.timestamp"
value="true"/>
</properties>
</persistence-unit>
</persistence>
the second problem is just the question how I can configure Eclipselink
for connect toward a MySQL Cluster.
At the moment we are use the loadbalance extension in the mysql/jdbc url
like this
"jdbc:mysql:loadbalance://10.0.3.11:3306,10.0.3.12:3306/database". That
works fine and extend the time between start and no inserts. To reach
that the database will save on the cluster we have to modify the create
script which is generates by the eclipselink. The engine has to set to
ndbcluster for distribute the table in the cluster.
But is there a option to configure such Cluster things in the
persistence.xml or somewhere in the code?
we and specially I looking forward to any hint that anyone can gives us.
Thanks for each answer
Sebastian
-------------------------------------------------------
Sebastian Weber, M.Sc.
Forschungsgruppe Verkehrstelematik
- Research Team Intelligent Transportation Systems
Fakultät für Ingenieurwissenschaften
- School of Engineering
Hochschule für Technik und Wirtschaft des Saarlandes (HTW)
- University of Applied Sciences
HTZ Hochschul-Technologie-Zentrum
Altenkesseler Strasse 17/D2
66115 Saarbruecken
Room: 81
Tel: +49 681 5867-663
Fax: +49 681 5867-671
E-Mail: sebastian.weber@xxxxxxxxxxxxxxx
URL: http://www.htw-saarland.de
-----------------------------------------
Attachment:
JPAEclipselinkInsertTests.pdf
Description: Adobe PDF document