Bug #49963 RFE: mysqldumpslow --explain
Submitted: 28 Dec 2009 17:12 Modified: 28 Dec 2009 17:22
Reporter: Kevin Benton Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[28 Dec 2009 17:12] Kevin Benton
Description:
We have a cron job that automatically sends us a list of the top 20 queries of the week.  It would be very helpful if we could ask mysqldumpslow to also do an explain on a per-query basis to help us get a quick sample of the way the optimizer might look at running the query again at the time the report is generated.  Yes, we understand that the explain can never be historic.  Same request also for --explain-extended.

How to repeat:
See description

Suggested fix:
See description
[28 Dec 2009 17:22] Valeriy Kravchuk
Thank you for the feature request.