Bug #43218 QUAN: Collect canonical Explain plans

• Submitted: 26 Feb 2009 9:47
• Reporter: Andrii Nikitin
• Status: Verified
• 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
• Triage: Needs Triage: D5 (Feature request)

[26 Feb 2009 9:47] Andrii Nikitin

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