MySQL Bugs: #43218: QUAN: Collect canonical Explain plans

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

Description:
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:
n/a

Suggested fix:
n/a