Bug #5694 'Explain mode' in client would be nice
Submitted: 22 Sep 2004 7:45 Modified: 10 Sep 2007 10:28
Reporter: yk Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:4.0.x and up OS:Linux (linux/SunOS)
Assigned to: CPU Architecture:Any

[22 Sep 2004 7:45] yk
Description:
When developing programs consisting basically of long series of queries processing huge data sets, it would be nice to be able to toggle an 'explain mode' causing the client to output the 'explain <query>' results before actually executing each query, maybe with a session variable or a command-line flag.

Cheers.

How to repeat:
This is only a low-prio feature addition suggestion.

Suggested fix:
Add an @@explain session variable to toggle the explain mode.
[10 Sep 2007 10:28] Valeriy Kravchuk
Thank you for a reasonable feature request. Something similar to Oracle's SET AUTOTRACE will be really useful in many cases.