Loading...

XML

Word

Printable

JSON

Type: Bug
Resolution: Duplicate
Priority: Major - P3
Fix Version/s: None
Affects Version/s: 2.6.4
Component/s: Querying
Labels:
None

Operating System:
ALL
Sprint:
Query 2.7.8
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

When we cache a plan, if subsequent queries produce significantly worse performance result than expected, the cached plan should be evicted.

It's currently evicted but the eviction strategy is too conservative so if we happen to cache a plan that works well only on a small minority of values we take too long to replace it.

duplicates

SERVER-15225 CachedPlanStage should execute for trial period and re-plan if query performs poorly

Closed

related to

SERVER-15924 planCacheListPlans command can report incorrect averageScore and stdDevScore in "feedback" section

Closed

Assignee:: David Storch
Reporter:: Asya Kamsky
Participants:: Asya Kamsky, David Storch
Votes:: 0 Vote for this issue
Watchers:: 8 Start watching this issue

Created:: Sep 03 2014 02:49:15 PM UTC
Updated:: Feb 17 2015 03:04:07 AM UTC
Resolved:: Feb 17 2015 03:04:07 AM UTC
Confidence Status Last Update:: 26/Sep/14 7:31 PM

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates