We are experiencing random slowness on certain queries. I have been unable
to diagnose what the issue is. We are using SOLR 1.4 and 99.99% of queries
return in under 250 ms. The remaining queries are returning in 2-5 seconds
for no apparent reason. There does not seem to be any commonality between
the queries. This problem also includes admin system queries. Any help or
direction would be much appreciated.
Specs:
Solr 1.4
Tomcat Server
4 cores
Largest core 155,000 documents.
Logs:
INFO: [zeta-main] webapp=null path=null params={command=details} status=0
QTime=1276
INFO: [zeta-main] webapp=null path=null params={command=details} status=0
QTime=1144
INFO: [zeta-main] webapp=null path=null params={command=details} status=0
QTime=1285
INFO: [zeta-main] webapp=/solr path=/select
params={facet=true&facet.mincount=1&facet.limit=-1&wt=javabin&rows=0&facet.s
ort=true&start=0&q=shoes&facet.field=colorFacet&facet.field=brandNameFacet&f
acet.field=heelHeight&facet.field=attrFacet_Style&qt=dismax&fq=productTypeFa
cet:Shoes&fq=gender:Womens&fq=categoryFacet:Sandals&fq=width:EE&fq=size:10.5
&fq=priceFacet:"$100.00+and+Under"&fq=personalityFacet:Sexy} hits=19
status=0 QTime=3689
INFO: [zeta-main] webapp=/solr path=/select
params={wt=javabin&rows=100&facet.sort=true&start=0&q=shoes&qt=dismax&fq=pro
ductTypeFacet:Shoes&fq=gender:Womens&fq=size:8&fq=width:D&fq=brandNameFacet:
Dansko} hits=8 status=0 QTime=3566
INFO: [zeta-main] webapp=/solr path=/select
params={wt=javabin&rows=100&facet.sort=true&start=0&q=shoes&qt=dismax&fq=gen
der:Womens&fq=productTypeFacet:Shoes&fq=subCategoryFacet:Heels&fq=categoryFa
cet:Shoes&fq=size:10} hits=5409 status=0 QTime=3348
INFO: [zeta-main] webapp=/solr path=/select
params={wt=javabin&rows=100&facet.sort=true&start=100&q=shoes&qt=dismax&fq=p
roductTypeFacet:Shoes&fq=gender:Womens&fq=personalityFacet:Dress&fq=category
Facet:Shoes&fq=size:10&fq=heelHeight:"Medium+(1+3/8in+-+2+1/2in)"} hits=1129
status=0 QTime=3285
INFO: [zeta-main] webapp=/solr path=/select
params={wt=javabin&rows=100&facet.sort=true&start=200&q=shoes&qt=dismax&fq=p
roductTypeFacet:Shoes&fq=gender:Womens&fq=categoryFacet:Shoes&fq=subCategory
Facet:Heels&fq=personalityFacet:Dress&fq=attrFacet_Style:Pump&fq=size:5}
hits=644 status=0 QTime=3750
INFO: [6pm-main] webapp=/solr path=/select
params={wt=javabin&rows=100&facet.sort=true&start=0&q=shoes&qt=dismax&fq=exp
andedGender:Kids&fq=productTypeFacet:Shoes&fq=gender:girls&fq=brandNameFacet
:"UGG+Kids"} hits=17 status=0 QTime=3789
--
Jeff Newburn
Software Engineer, Zappos.com
jnewb...@zappos.com - 702-943-7562
