performance issues on querying DMS repository
---------------------------------------------
Key: MAGNOLIA-3594
URL: http://jira.magnolia-cms.com/browse/MAGNOLIA-3594
Project: Magnolia
Issue Type: Bug
Affects Versions: 4.4.2
Environment: Ubuntu 10.04.2 LTS 64 bits
tomcat 6.0.24-2ubuntu1.6
mysql-server 5.1.41-3ubuntu12.10
Reporter: Jurjen de Groot
Assignee: Boris Kraft
Attachments: threaddump-annexum-test-2.tdump.zip
For a project we are querying the DMS for relevant documents, but when we are
simulating a request by only 15 users at the same time the server's processor
usage goes up to 100%. And all new requests are put on hold while the requests
are waiting for the previous requests to be handled.
We ran a thread dump including an analyzer. The dump is included as an
attachment.
Looking at the dump we can see that calling
info.magnolia.module.dms.beans.Document.isDocument() takes a long time and
subsequent threads are being blocked waiting for the call to end.
In the isDocument method jackrabbit is being accessed and that is where it
hangs.
Our config file holds the following settings for the persistancemanager:
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
<param name="driver" value="com.mysql.jdbc.Driver" />
<param name="url" value="jdbc:mysql://mydb" />
<param name="schema" value="mysql" /><!-- warning, this is not the schema
name, it's the db type -->
<param name="user" value="***" />
<param name="password" value="***" />
<param name="schemaObjectPrefix" value="${wsp.name}_" />
<param name="externalBLOBs" value="false" />
</PersistenceManager>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.magnolia-cms.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
