Mailing-List: contact allura-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: allura-dev@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of noreply@sourceforge.net
 designates 216.34.181.60 as permitted sender)
Content-Type: multipart/related;
 boundary="===============3142975979496869995=="
MIME-Version: 1.0
To: allura-dev@incubator.apache.org
From: "Dave Brondsema" <brondsem@users.sf.net>
Reply-To: "Ticket 7065" <7065@tickets.allura.p.re.sf.net>
Subject: [allura:tickets] #7065 Slow post queries happening on invalid URLs
Message-ID: <52d80c2904161f168a658b0e.tickets@allura.p.sourceforge.net>
Date: Thu, 16 Jan 2014 16:43:22 +0000

--===============3142975979496869995==
Content-Type: multipart/alternative;
 boundary="===============0341360432980656113=="
MIME-Version: 1.0

--===============0341360432980656113==
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit


---

** [tickets:#7065] Slow post queries happening on invalid URLs**

**Status:** in-progress
**Labels:** performance 
**Created:** Thu Jan 16, 2014 04:43 PM UTC by Dave Brondsema
**Last Updated:** Thu Jan 16, 2014 04:43 PM UTC
**Owner:** Dave Brondsema

On a URL like `/p/foobar/tickets/_discuss/thread/092b4865/3547/blah/blah/bogus` the response is quite slow, e.g. stats.log: `"timings": {"total": 466534, "mongo": 466506, "ming": 466516}}}`

This is due to an unindexed mongo query: `query project-data.post query: { slug: "3547/blah/blah/bogus" } ntoreturn:0 ntoskip:0 nscanned:19604 keyUpdates:0 numYields: 503 locks(micros) r:37235 nreturned:0 reslen:20 5253ms`


---

Sent from sourceforge.net because allura-dev@incubator.apache.org is subscribed to https://sourceforge.net/p/allura/tickets/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/allura/admin/tickets/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.
--===============0341360432980656113==
MIME-Version: 1.0
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: 7bit

<div class="markdown_content"><hr />
<p><strong> <a class="alink" href="http://sourceforge.net/p/allura/tickets/7065/">[tickets:#7065]</a> Slow post queries happening on invalid URLs</strong></p>
<p><strong>Status:</strong> in-progress<br />
<strong>Labels:</strong> performance <br />
<strong>Created:</strong> Thu Jan 16, 2014 04:43 PM UTC by Dave Brondsema<br />
<strong>Last Updated:</strong> Thu Jan 16, 2014 04:43 PM UTC<br />
<strong>Owner:</strong> Dave Brondsema</p>
<p>On a URL like <code>/p/foobar/tickets/_discuss/thread/092b4865/3547/blah/blah/bogus</code> the response is quite slow, e.g. stats.log: <code>"timings": {"total": 466534, "mongo": 466506, "ming": 466516}}}</code></p>
<p>This is due to an unindexed mongo query: <code>query project-data.post query: { slug: "3547/blah/blah/bogus" } ntoreturn:0 ntoskip:0 nscanned:19604 keyUpdates:0 numYields: 503 locks(micros) r:37235 nreturned:0 reslen:20 5253ms</code></p>
<hr />
<p>Sent from sourceforge.net because allura-dev@incubator.apache.org is subscribed to <a href="https://sourceforge.net/p/allura/tickets/">https://sourceforge.net/p/allura/tickets/</a></p>
<p>To unsubscribe from further messages, a project admin can change settings at <a href="https://sourceforge.net/p/allura/admin/tickets/options.">https://sourceforge.net/p/allura/admin/tickets/options.</a>  Or, if this is a mailing list, you can unsubscribe from the mailing list.</p></div>
--===============0341360432980656113==--

--===============3142975979496869995==--