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