[SERVER-8871] Support admin hints per query pattern Created: 06/Mar/13  Updated: 27/Oct/15  Resolved: 15/Jan/14

Status: Closed
Project: Core Server
Component/s: Admin, Diagnostics, Logging, Querying
Affects Version/s: None
Fix Version/s: 2.5.5

Type: New Feature Priority: Major - P3
Reporter: Daniel Pasette (Inactive) Assignee: Benety Goh
Resolution: Done Votes: 2
Labels: query_triage
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Related
related to SERVER-9306 Ability to temporarily forbid query o... Closed
related to SERVER-5470 View memorized query optimized plans Closed
related to DOCS-2595 add index filter commands Closed
related to SERVER-666 query optimizer introspection Closed
related to SERVER-8692 Add logging to indicate when cached q... Closed
is related to SERVER-12358 Add query plan history and logging Closed
Backwards Compatibility: Fully Compatible
Participants:

 Description   

The query optimizer currently generates a query plan which is cached and re-used based on the normalized "shape" of the query predicate and sort criteria.

  1. Querying
    DBA's should be able to hint a query by plan id. This should be able to be set by a DBA on the server-side in addition to the current technique of putting the hint into the application itself.


 Comments   
Comment by Githook User [ 15/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-8871 admin hints
Branch: master
https://github.com/mongodb/mongo/commit/9b94912fe8847977c4d23a12604cb900e6f426b7

Comment by Githook User [ 07/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-8871 derive plan cache key from query, sort and projection
Branch: master
https://github.com/mongodb/mongo/commit/57364a7de52c030af0d305c918de7180d0459ed1

Comment by Githook User [ 19/Dec/13 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-8871 removed default switch case from encodeMatchType
Branch: master
https://github.com/mongodb/mongo/commit/9a34ccdde43942a4095c7a5b7285096993ed4860

Comment by Githook User [ 18/Dec/13 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-8871 added sorting of cacheable queries and plan cache key generation
Branch: master
https://github.com/mongodb/mongo/commit/e2a66c54f5ae80f0055ed3b09799b717842e4f25

Comment by Aaron Staple [ 06/Mar/13 ]

The ability to configure a persistent hint based on the query pattern sounds useful and I believe is unique to this ticket.

Adding reporting info for the query optimizer's plan selection behavior also sounds useful. I think there is some overlap between this and the three other tickets listed in the "related to" section which also describe ways of accessing this information. When we spec out what we want to implement, we may want to consolidate these tickets.

Generated at Thu Feb 08 03:18:41 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.