You should be able to mine the logs for the query, as:
webapp=/solr path=/select params={q=manu:samsung} hits=1 status=0 QTime=3

Admittedly you have to do some reconstruction, but it's there. From there,
you should
be able to run the query against a warmed Solr (but not one that has had
that particular
query run before).

My guess is you're hitting the first time something is done, like sorting
or some such
occasionally on these queries by chance when a new searcher is opened.

Best
Erick


On Thu, Aug 1, 2013 at 4:06 PM, jimtronic <jimtro...@gmail.com> wrote:

> Thanks. I'd rather not turn off caching completely because it only seems to
> show up in production and I don't want to turn reboot all the solr
> processes on each node.
>
> Jim
>
> On Thu, Aug 1, 2013 at 12:30 PM, Roman Chyla [via Lucene] <
> ml-node+s472066n4082014...@n3.nabble.com> wrote:
>
> > When you set your cache (solrconfig.xml) to size=0, you are not using a
> > cache. so you can debug more easily
> >
> > roman
> >
> >
> > On Thu, Aug 1, 2013 at 1:12 PM, jimtronic <[hidden email]<
> http://user/SendEmail.jtp?type=node&node=4082014&i=0>>
> > wrote:
> >
> > > I have a query that runs slow occasionally. I'm having trouble
> debugging
> > it
> > > because once it's cached, it runs fast -- under 10 ms. But throughout
> > the
> > > day it occasionally takes up to 3 secs. It seems like it could be one
> of
> > > the
> > > following:
> > >
> > > 1. My autoCommit (300000 and openSearcher=false) and softAutoCommit
> > (10000)
> > > settings
> > > 2. Something to do with distributed search -- There are three nodes,
> but
> > > only 1 shard each.
> > > 3. Just a slow query that is getting blown out of cache periodically
> > >
> > > This is in Solr 4.2.
> > >
> > > I like that it runs fast when cached, but if it's going to be blown out
> > > quickly, then I'd really like to just optimize the query to run fast
> > > uncached.
> > >
> > > *Is there any way to run a query using no caching whatsoever?*
> > >
> > > The query changes, but has *:* for the q param and 4 fq parameters.
> It's
> > > also trying to do field collapsing.
> > >
> > > Jim
> > >
> > >
> > >
> > >
> > > --
> > > View this message in context:
> > >
> >
> http://lucene.472066.n3.nabble.com/How-to-uncache-a-query-to-debug-tp4082010.html
> > > Sent from the Solr - User mailing list archive at Nabble.com.
> > >
> >
> >
> > ------------------------------
> >  If you reply to this email, your message will be added to the discussion
> > below:
> >
> >
> http://lucene.472066.n3.nabble.com/How-to-uncache-a-query-to-debug-tp4082010p4082014.html
> >  To unsubscribe from How to uncache a query to debug?, click here<
> http://lucene.472066.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4082010&code=amltdHJvbmljQGdtYWlsLmNvbXw0MDgyMDEwfDEzMjQ4NDk0MTQ=
> >
> > .
> > NAML<
> http://lucene.472066.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
> >
> >
>
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/How-to-uncache-a-query-to-debug-tp4082010p4082047.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>

Reply via email to