-
Type: Bug
-
Resolution: Duplicate
-
Priority: Critical - P2
-
None
-
Affects Version/s: 2.6.5
-
Component/s: Index Maintenance, Performance, Querying
-
None
-
Linux
-
Sporadic performance issue affecting a simple query.
{ "$query" : { "a_token" : "*******************"} , "$orderby" : { "_id" : 1}}
No index misses are being reported. Most of the time the query returns in under 1ms. On occasion we run up to 2000+ms. running the query manually during these times shows the same. If I remove the orderby the query returns as expected. Seems to be running out of order.
- duplicates
-
SERVER-15225 CachedPlanStage should execute for trial period and re-plan if query performs poorly
- Closed
- is related to
-
SERVER-18507 A query will take very long time in a sudden but it works well in most time.
- Closed
- related to
-
SERVER-17362 ClientCursor::staticYield can't unlock b/c of recursive lock ns
- Closed