You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@jackrabbit.apache.org by Marcel Reutegger <ma...@gmx.net> on 2008/06/24 11:46:24 UTC

Re: Logging/Detecting slow JCR queries with Lucene

Hi,

sbarriba wrote:
> Hi all,
> 
> Our application makes quite heavy use of JCR queries. We're seeing some
> scenarios where the IO utilisation is very high for a period of time. A
> thread dump of Tomcat shows lots and lots of threads locked waiting on
> <0x781fe1d0> (a org.apache.lucene.store.FSDirectory$FSIndexInput which is
> locked by the thread below.

not sure, but this might be related to: 
https://issues.apache.org/jira/browse/JCR-1365

> Given we have 140+ queries being used, is there a way to configure
> JackRabbit and/or Lucene to log out slow queries equivalent to the
> "log-slow-queries" provided by MySql?

when you enable debug log messages for 
org.apache.jackrabbit.core.query.QueryImpl you will see timing information as 
well as the query statement, though you'll have to post process that information 
because *all* queries will be logged, not just slow ones.


regards
  marcel

RE: Logging/Detecting slow JCR queries with Lucene

Posted by sbarriba <sb...@yahoo.co.uk>.

Thanks Marcel. We'll look at enabling this logging.

Are there any tuning params we should be looking at to help with the
performance in this area in the short term?

Regards,
Shaun

-----Original Message-----
From: Marcel Reutegger [mailto:marcel.reutegger@gmx.net] 
Sent: 24 June 2008 10:46
To: users@jackrabbit.apache.org
Subject: Re: Logging/Detecting slow JCR queries with Lucene

Hi,

sbarriba wrote:
> Hi all,
> 
> Our application makes quite heavy use of JCR queries. We're seeing some
> scenarios where the IO utilisation is very high for a period of time. A
> thread dump of Tomcat shows lots and lots of threads locked waiting on
> <0x781fe1d0> (a org.apache.lucene.store.FSDirectory$FSIndexInput which is
> locked by the thread below.

not sure, but this might be related to: 
https://issues.apache.org/jira/browse/JCR-1365

> Given we have 140+ queries being used, is there a way to configure
> JackRabbit and/or Lucene to log out slow queries equivalent to the
> "log-slow-queries" provided by MySql?

when you enable debug log messages for 
org.apache.jackrabbit.core.query.QueryImpl you will see timing information
as 
well as the query statement, though you'll have to post process that
information 
because *all* queries will be logged, not just slow ones.

regards
  marcel