MySQL Bugs: #5694: 'Explain mode' in client would be nice

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

Thank you for a reasonable feature request. Something similar to Oracle's SET AUTOTRACE will be really useful in many cases.