- 
    Type:Bug 
- 
    Resolution: Duplicate
- 
    Priority:Critical - P2 
- 
    None
- 
    Affects Version/s: 2.6.5
- 
    Component/s: Index Maintenance, Performance, Querying
- 
    None
- 
        Linux
- 
        
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
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
 
-