Bug #43218 QUAN: Collect canonical Explain plans
Submitted: 26 Feb 2009 9:47
Reporter: Andrii Nikitin Email Updates:
Status: Verified Impact on me:
Category:MySQL Enterprise Monitor: Agent Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: windmill

[26 Feb 2009 9:47] Andrii Nikitin
Since the same query may be executed using different plan, (depends on parameters values, server settings, engine statistics, index availability, etc):

It would be nice to have track of all possible canonical execution plans: e.g. have option to show in 'Browse Queries' grouping by (canonical query, execution plan), e.g.

| Query                    |Plan | Max |
|select * from t where a=? | all | 2.7 |...
|select * from t where a=? | ref | 1.3 |...

This will give advantage, like:
1. compare effectiveness of certain plans
2. see effect of introducing new indexes
3. see when execution plan changed (first appeared, etc)

How to repeat:

Suggested fix: