You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@allura.apache.org by Dave Brondsema <br...@users.sf.net> on 2014/01/16 17:43:22 UTC
[allura:tickets] #7065 Slow post queries happening on invalid URLs
---
** [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.
[allura:tickets] #7065 Slow post queries happening on invalid URLs
Posted by Cory Johns <ma...@users.sf.net>.
- **status**: code-review --> closed
---
** [tickets:#7065] Slow post queries happening on invalid URLs**
**Status:** closed
**Labels:** performance
**Created:** Thu Jan 16, 2014 04:43 PM UTC by Dave Brondsema
**Last Updated:** Thu Jan 16, 2014 05:51 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.
[allura:tickets] #7065 Slow post queries happening on invalid URLs
Posted by Dave Brondsema <br...@users.sf.net>.
- **status**: in-progress --> code-review
---
** [tickets:#7065] Slow post queries happening on invalid URLs**
**Status:** code-review
**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.
[allura:tickets] #7065 Slow post queries happening on invalid URLs
Posted by Cory Johns <ma...@users.sf.net>.
- **QA**: Cory Johns
---
** [tickets:#7065] Slow post queries happening on invalid URLs**
**Status:** code-review
**Labels:** performance
**Created:** Thu Jan 16, 2014 04:43 PM UTC by Dave Brondsema
**Last Updated:** Thu Jan 16, 2014 05:37 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.
[allura:tickets] #7065 Slow post queries happening on invalid URLs
Posted by Dave Brondsema <br...@users.sf.net>.
db/7065
---
** [tickets:#7065] Slow post queries happening on invalid URLs**
**Status:** code-review
**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.